Viewing 15 posts - 2,086 through 2,100 (of 8,416 total)
mazzz (2/28/2011)
So, 12 million row locks and only 2 lock promotions, only 2 attempts?
Are you certain those operational statistics are for the index being used by the query in question?
Do...
February 28, 2011 at 5:29 am
prady_1988 (2/28/2011)
Thanks guys. It was in fact an extended stored procedure. Found it
Cool. When you get a chance, ask whoever provided it when they will be replacing it with...
February 28, 2011 at 12:24 am
A couple of tweaks to Jeff's code, mostly for correctness, not speed. It will be interesting to see how the Tally code performs.
;
WITH cteFirstSplit
AS ...
February 28, 2011 at 12:21 am
JJH82 (2/27/2011)
yes, I can create or use stored procedures on the server.:crazy:but i have not .Net programming experience
OK. I was suggesting a .NET stored procedure or function, so that...
February 27, 2011 at 10:53 pm
Jeff Moden (2/27/2011)
February 27, 2011 at 8:52 pm
Jeff Moden (2/27/2011)
Heh... you should practice what you preach in this case. 😉
Heh. No. My comments were as much for daveriya's benefit as anyone else's - so quite...
February 27, 2011 at 8:50 pm
JJH82 (2/27/2011)
yes, i believe so
Specifically, I am asking if it is OK to use a SQLCLR stored procedure or function on this SQL Server. Do you have any experience...
February 27, 2011 at 8:14 pm
Jeff Moden (2/27/2011)
I found it under "partitioning schemes" in BOL... not under "partitioned views".
The is a good deal of coverage of this topic in BOL, in separate entries. The...
February 27, 2011 at 8:10 pm
pietlinden (2/27/2011)
February 27, 2011 at 8:00 pm
Craig,
Look up Partitioned Views in Books Online.
Paul
February 27, 2011 at 7:44 pm
JJH82 (2/27/2011)
I created a loop to process 1000 Records at a time. any comments or...
February 27, 2011 at 7:39 pm
Jeff Moden (2/27/2011)
February 27, 2011 at 7:33 pm
daveriya (2/27/2011)
At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level.
If you just want to check the...
February 27, 2011 at 7:28 pm
You're welcome. You should probably create a permanent numbers table - they come in very handy for all sorts of things.
February 27, 2011 at 5:35 am
Viewing 15 posts - 2,086 through 2,100 (of 8,416 total)