Viewing 15 posts - 4,531 through 4,545 (of 9,399 total)
Reinforcing what Perry said, I recently deployed a new SQL Server on Windows 2012 and found the failover clustering to be much better than it was on Windows 2008.
Another issue...
December 8, 2015 at 9:38 am
Another point to consider is that scalar functions have to run once for each row. If you have two functions, each one has to run once for each row.
If...
December 8, 2015 at 9:32 am
Sean Lange (12/8/2015)
Ed Wagner (12/8/2015)
Sean Lange (12/8/2015)
Ed Wagner (12/8/2015)
Sean Lange (12/7/2015)
Alan.B (12/7/2015)
Sean Lange (12/7/2015)
December 8, 2015 at 7:47 am
Sean Lange (12/8/2015)
Ed Wagner (12/8/2015)
Sean Lange (12/7/2015)
Alan.B (12/7/2015)
Sean Lange (12/7/2015)
December 8, 2015 at 7:34 am
Eirikur Eiriksson (12/8/2015)
BrainDonor (12/8/2015)
Here's one I've never seen before - every thread on a full page of the search started by the same person.Someone is very busy.
Too busy for RTFM
😎
Now...
December 8, 2015 at 7:01 am
Sean Lange (12/7/2015)
Alan.B (12/7/2015)
Sean Lange (12/7/2015)
December 8, 2015 at 6:58 am
anthony.green (12/8/2015)
Stuart Davies (12/8/2015)
Revenant (12/7/2015)
ZZartin (12/7/2015)
DonlSimpson (12/7/2015)
whereisSQL? (12/7/2015)
djj (12/7/2015)
Ed Wagner (12/5/2015)
DonlSimpson (12/5/2015)
Ed Wagner (12/5/2015)
TomThomson (12/5/2015)
DonlSimpson (12/4/2015)
djj (12/4/2015)
crookj (12/4/2015)
Ed Wagner (12/4/2015)
crookj (12/4/2015)
RabbitSeason
Duck
Season (sorry could not resist)
Rabbit (go with...
December 8, 2015 at 6:57 am
ramana3327 (12/7/2015)
Thanks for your replies.
I am working the similar kind. I am using the same query but just the columns are different.
In the query there is an end time, which...
December 8, 2015 at 6:29 am
GilaMonster (12/7/2015)
Ed Wagner (12/4/2015)
A SELECT TOP 1...ORDER BY would also do the trick.
Not necessarily. RowNumber can do grouping, and so return one row per partition. Top 1 is just top...
December 8, 2015 at 5:40 am
Thanks for a relatively simple one, Steve. I kept looking for the trick. 😉 I do appreciate straight-forward questions.
December 8, 2015 at 5:26 am
Hugo Kornelis (12/7/2015)
Red Gate publishing has a book by Grant Fritchey (https://www.red-gate.com/community/books/sql-server-execution-plans-ed-2). You can download the PDF version for free, and the print copy won't cost you an arm and...
December 8, 2015 at 5:23 am
DonlSimpson (12/5/2015)
Ed Wagner (12/5/2015)
TomThomson (12/5/2015)
DonlSimpson (12/4/2015)
djj (12/4/2015)
crookj (12/4/2015)
Ed Wagner (12/4/2015)
crookj (12/4/2015)
RabbitSeason
Duck
Season (sorry could not resist)
Rabbit (go with it)
Welsh (rabbit)
Cheese
Wallace
William
December 5, 2015 at 6:03 pm
Viewing 15 posts - 4,531 through 4,545 (of 9,399 total)