Viewing 15 posts - 2,236 through 2,250 (of 49,571 total)
tahirfarooq (10/14/2016)
Can you give me example code Plz
Gianluca gave you an example you can start from.
October 14, 2016 at 5:05 am
BrainDonor (10/14/2016)
October 14, 2016 at 5:03 am
Easy enough, you've got the queries. Schedule them run for a day or so.
But I suspect you're looking in the wrong place. Deadlocks are extremely unlikely to be caused by...
October 14, 2016 at 5:01 am
Keep it simple, an update to Products from deleted, use the pseudotable to see the quantity on the deleted rows.
No cursors, no loops!
October 14, 2016 at 2:05 am
river1 (10/14/2016)
Available physical memory is high
There's your answer on the memory
October 14, 2016 at 1:55 am
Grant Fritchey (10/13/2016)
Sean Lange (10/13/2016)
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or...
October 13, 2016 at 8:17 am
river1 (10/13/2016)
Is there a way to see if SQL server is asking for more memory?
Deadlocks are unlikely to be caused by insufficient memory. They're caused usually by inefficient queries and/or...
October 13, 2016 at 8:10 am
BLOB_EATER (10/13/2016)
I watched your sqlbits conference ( first time I got to see what you look like) I thought you were mid 30s..
Not too far off. 40 later this year...
October 13, 2016 at 6:28 am
20 years ago I was at University. 2nd year specifically, Maths, Physics, Computer Science.
And I'm one of the oldest people at my current company (CEO is 2 years younger than...
October 13, 2016 at 6:05 am
JasonClark (10/12/2016)
In management studio the database will be shown with "Recovery Pending" in front of its name, delete...
October 13, 2016 at 3:19 am
Why do you say the log isn't being truncated? Where are you looking and what are you expecting to see that you aren't?
October 13, 2016 at 3:09 am
Without some custom monitoring or auditing, you can't.
The procedure_stats DMV shows execution count since the procedure was last compiled, but that's all you can get, and last compile won't usually...
October 12, 2016 at 3:53 am
Rod at work (10/11/2016)
October 12, 2016 at 3:29 am
BLOB_EATER (10/12/2016)
October 12, 2016 at 3:23 am
Brandie Tarvin (10/11/2016)
GilaMonster (10/10/2016)
Brandie Tarvin (10/10/2016)
Hugo, are you heading west (over the Atlantic) or east (over the Pacific) on your Amsterdam to Seattle leg?
North. The flight goes over Greenland and...
October 11, 2016 at 4:26 am
Viewing 15 posts - 2,236 through 2,250 (of 49,571 total)