Viewing 15 posts - 10,696 through 10,710 (of 22,213 total)
Saravanan_tvr (6/25/2012)
June 25, 2012 at 5:39 am
Prior to upgrading any of these databases, run the free tool from Microsoft, the SQL Server 2012 Upgrade Advisor. It will validate if you have any T-SQL coding issues or...
June 25, 2012 at 5:09 am
Take a look at the execution plan for the query. When looking at the execution plan, drill down to the properties of the joins and you should be able to...
June 25, 2012 at 5:06 am
From what I can tell, everyone has a slightly different take on this. My goal is #1, the promotion of Red Gate Software, the company and it's products. I really...
June 25, 2012 at 4:59 am
Once you've moved it up to the new version, yes, it will get the new limit. Be sure you set the compatibility level on the database too so that you...
June 25, 2012 at 4:57 am
The only way to know for sure whether or not changing the location of the clustered index is going to speed things up is to test it.
If your primary access...
June 25, 2012 at 4:30 am
So DB2 never, ever has a backup that they're unable to restore? Wow! that's pretty cool.
Oh, wait[/url]. Well that was just one... ummm... Well it's... ahhh...[/url] .... Nevermind.
And that was...
June 22, 2012 at 9:39 am
I really don't want to sound mean, but what a mess. Why do you have so many different instances all running on the same machine?
But, to answer your question, yes,...
June 22, 2012 at 5:13 am
Instead of loading temporary tables first, just join to the original tables in the DELETE statements. That eliminates a step of processing right there.
June 22, 2012 at 5:06 am
Version 7 of SQL Backup does have VERIFY ONLY as part of the GUI, just so you know.
But, as was already pointed out, you can script the whole thing and...
June 21, 2012 at 7:29 am
patrickmcginnis59 (6/21/2012)
Grant Fritchey (6/21/2012)
“By now, you might be able to see where I’m going in this section....
June 21, 2012 at 6:47 am
Queries to return a single record should be able to be tuned to a fare-thee-well. It just depends on the parameters being passed in and how well you can apply...
June 21, 2012 at 6:26 am
Have to make the comment, this is a classic example of using data types appropriately. If it's a number, store it as a number and refer to it as a...
June 21, 2012 at 6:19 am
Just received an interesting comment on this over on my blog that included this:
“By now, you might be able to see where I’m going in this section. I have made...
June 21, 2012 at 4:13 am
L' Eomot Inversé (6/20/2012)
But I may not find...
June 21, 2012 at 3:53 am
Viewing 15 posts - 10,696 through 10,710 (of 22,213 total)