Viewing 15 posts - 61 through 75 (of 82 total)
What option you dont have? script data option or Generate Script option?
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 14, 2010 at 4:23 am
As Dave Ballantyne said, if you can provide sql query and execution plans from both the servers then it will be helpful provide any advice.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 14, 2010 at 4:07 am
Completely agree with eric_russell, I think there is no comparison between coding on GUI and on database, there are so many features to handle things same as you we do...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 14, 2010 at 3:07 am
Check the indexes and their fragmentation levels. if they are identical then there should not me more difference.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 14, 2010 at 2:40 am
Confused with your question, what do you mean by combining multiple databases into a single, you mean to transfer the tables and other objects form different databases to single?
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 11:17 pm
I had similar kind of problem whereas i was not even able to see any databases in object explorer of SSMS2008 but quires were running fine, but this article helped...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 9:53 pm
Hay Post your data in the form of INSERT statements which will help people who want to help you. you should probably study the article in the link below. It'll...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 3:12 am
Try this query, no need of using sub query:
SELECT Gender, CMType, BreedName, COUNT(*) AS 'Nr By Gender/Type/Breed'
FROM BREED JOIN K9 AS CNTR
ON BREED.BreedID = CNTR.BreedID
JOIN CMTYPE ON CNTR.CMID = CMTYPE.CMID
GROUP...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 3:06 am
I think you are missing group by clause for the main query.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 2:31 am
search for mru.dat file in Application Data folder and delete that file.
Hope that should work.
Thanks,
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 11, 2010 at 2:18 am
I am sorry ColdCoffee I pointed my reply to Jeff whereas you are the one who wrote the code... I started participating on this forum frequently which is giving me...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 7, 2010 at 7:44 am
give some example for the rate column of second table.
Nags
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 7, 2010 at 4:19 am
One thing I have understood from all these great personalities is that, there is no end for hunger and there is no end for learning.
Thanks,
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 7, 2010 at 1:18 am
Jeff i learned more about CTE from this post as I have started my carrier as SQL Developer, but for 3 to 4 years i am working as DBA, but...
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 7, 2010 at 12:58 am
To get list of orphaned users user the following query
USE databasename;
GO
EXECUTE sp_change_users_login @Action='Report';
To fix the Orphaned users logins one at a time
USE databasename;
GO
EXEC sp_change_users_login 'Update_One', 'database_User', 'ServerlevelDet'
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 6, 2010 at 4:34 am
Viewing 15 posts - 61 through 75 (of 82 total)