Viewing 15 posts - 7,456 through 7,470 (of 14,953 total)
Since I prefer as much consistency as possible, I try to stick to Coalesce. There are times when I can't use IsNull and have to use Coalesce, but there...
December 11, 2009 at 7:43 am
I've got one CLR procedure in use, which checks drive space available on a network share before running backups. Pretty much the same functionality as xp_fixeddrives, but works on...
December 11, 2009 at 7:39 am
Google/Bing/Dogpile/whatever would be a good place to start.
December 11, 2009 at 7:29 am
CirquedeSQLeil (12/10/2009)
I take off for a few hours to work on my presentation (asked last minute to present at meeting tonight) and the thread goes berserk.WOW.
Yeah, it tends to do...
December 10, 2009 at 3:28 pm
Where I'd start would be the execution plans on both servers. Compare those, see what's different.
If you can't get the old SQL 2000 execution plans, then look at the...
December 10, 2009 at 2:58 pm
Lynn Pettis (12/10/2009)
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:
When you date...
December 10, 2009 at 1:19 pm
It can do some short-circuiting, but it has to include all possibilities in the execution plan.
Sometimes, you can improve performance and create a simpler execution plan by using Unions instead...
December 10, 2009 at 12:56 pm
Bru Medishetty (12/10/2009)
GSquared (12/10/2009)
Or fire up Windows Task Manager and take a look at what's running. But that might be too easy and too direct.
Gus, how to fire Windows...
December 10, 2009 at 12:28 pm
Roy Ernest (12/10/2009)
To be honest, There are lots of Indians here who give other Indians a bad name... 🙁
And plenty of Americans who give us a bad name. And...
December 10, 2009 at 12:27 pm
Are you asking about load balancing? If so, the easiest way to do that in this case would be to hook all the physical servers together into a single...
December 10, 2009 at 12:20 pm
Lynn Pettis (12/10/2009)
Krasavita (12/10/2009)
Are there other apps on the server that SQL has to share the box with.
How Can I check other apps on the server that SQL has...
December 10, 2009 at 12:17 pm
I'd have to see more of your proc to know what's going on.
I just ran this, and it had no problem accessing the variable:
create proc dbo.TryCatch
as
set nocount on;
declare @X int;
select...
December 10, 2009 at 12:15 pm
Lynn Pettis (12/10/2009)
CirquedeSQLeil (12/10/2009)
GilaMonster (12/10/2009)
Krasavita (12/10/2009)
I already have AWE check and I have Standard Edition.
If you have Standard edition of SQL 2000 then this entire...
December 10, 2009 at 11:56 am
Just put the formula in your Where clause. No need for cursors.
December 10, 2009 at 11:55 am
ray 78019 (12/10/2009)
If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be saved as...
December 10, 2009 at 8:51 am
Viewing 15 posts - 7,456 through 7,470 (of 14,953 total)