Viewing 15 posts - 286 through 300 (of 514 total)
Another thing. I just restored 4 databases from production to our test environment. (took all of 2 minutes).
In my past life, I would have requested 2...
October 5, 2007 at 6:44 am
Vladimiro Buda (10/5/2007)
After reading this editorial (???), I think about unsubscribing me from this site!Says something without justify it, bahhhh
It's a JOKE :laugh:
Let me put it this way....
October 5, 2007 at 6:36 am
Brandie Tarvin (10/4/2007)
They must have made it out of the same material as the Great Pyramids of Giza. @=)
I just assumed that you were talking about a twinkie
October 5, 2007 at 6:08 am
Sorry, Don't have a 2000 instance anymore to work with, but with the 2005 profiler you CAN see both the MODE and the TYPE of the locks aquired.
/****************************************************/
/*...
October 4, 2007 at 2:50 pm
Temp Table?
October 4, 2007 at 2:18 pm
Use the Profiler You can configure it to watch for pretty much anything the session might do.
October 4, 2007 at 2:04 pm
It sounds like you have what is referred to as a side by side installation. In order to accomplish this you had to have created a NAMED instance in...
October 4, 2007 at 6:48 am
In what part is the UPDATE statement there ? ;)[/quote]
Sorry here is the whole thing.
[ WITH [...n] ]
UPDATE
[ TOP ( expression ) [...
October 3, 2007 at 1:25 pm
The performance Dashboard that can be used with 2k5 SP2+ makes reading the sys.dm_missing_index views more readable.
FYI, they are not always good choices. You have to try...
October 3, 2007 at 8:59 am
FROM BOL
SET @variable = column = expression sets the variable to the same value as the column. This differs from SET @variable = column, column = expression, which sets the...
October 3, 2007 at 8:41 am
Ninja's_RGR'us (10/2/2007)
What is it for?
Stocks and such. We have about 50 performance markers for a stock, bond etc. Rarely are we looking at more than 1 or two,...
October 3, 2007 at 6:56 am
hmmm. Well, I guess the good news here is that this code isn't controlling a missile launch system or anything like that. However, I will keep that...
October 2, 2007 at 5:20 pm
An Update
The @Dummy= is required. Well at least if you want the value to be right 🙂 The statement will run, but the value will be wrong. ...
October 2, 2007 at 3:09 pm
Not recommending them one way or the other, but there is this software:
October 2, 2007 at 1:56 pm
Problem 2.
Date,Week,Month,Daily_Type1,Monthly_Type2
2006-11-29 00:00:00.000,5577,1283,0.176767241809893,NULL
2006-11-30 00:00:00.000,5578,1283,0.206843646769383,0.467677951418334
Drop PK index
create unique clustered index #TmpPK on #ComplexFilter(AsOfDate DESC) -- Change order
UPDATE #ComplexFilter
SET
@CurrMonthly_Type2 = CASE WHEN Monthly_Type2 IS NULL THEN @CurrMonthly_Type2 ELSE Monthly_Type2...
October 2, 2007 at 12:31 pm
Viewing 15 posts - 286 through 300 (of 514 total)