Viewing 15 posts - 1 through 15 (of 24 total)
I must be misreading the reference information.
Permissions
User must have VIEW SERVER STATE permission to access information from the sys.dm_exec_background_job_queue dynamic management view.
KILL STATS JOB permissions default to the members of...
January 10, 2017 at 4:58 am
The correct answer is 284, oh wait that was Canada, Eh!
November 24, 2016 at 7:55 am
Thom A (10/11/2016)
Really wasn't expecting that answer. The skeptic in me does wonder how many people ran the SQL before giving an answer though 🙂
I selected my answer (execute with...
October 11, 2016 at 10:35 am
Just my 2 cents.
database crashed and it should be restored with minimal data loss using existing files
Option 3 is faster, you are losing data every second after the crash too;...
September 30, 2015 at 12:38 pm
Iwas Bornready (6/11/2015)
I knew it would error with some kind of overflow error but I don't have all the error codes memorized.
+1
Figured it out by elimination:
1000 - wrong
220 - no...
June 11, 2015 at 7:15 am
Brian Hibbert (1/29/2015)
Great question, and I nearly clicked 0 because '2014' = True SHOULD fail, but doesn't in SQL.
So this is the real answer. Much better than the...
January 29, 2015 at 7:43 am
mhynds (1/26/2015)
January 26, 2015 at 6:55 am
Thank for the question. I have been using NOCOUNT in my SP for years (OJT sql development) but did not fully understand the benefit. Now at least I have a...
December 11, 2014 at 7:29 am
Hany Helmy (12/10/2014)
paul.knibbs (12/10/2014)
Emil Bialobrzeski (12/10/2014)
1+1+1+1+1+1+1+1+1+1+1+1x0+1 = ?
most of the answers was 1. So saying Simple may apply differently to...
December 10, 2014 at 7:06 am
dale_berta (12/8/2014)
Granted, not useful in...
December 8, 2014 at 2:49 pm
david.gugg (12/5/2014)
Wow, I've never had to do bitwise operations. I totally interpreted that as a math problem (one to the one hundredth power).Thanks for the question!
Made the same math...
December 5, 2014 at 9:40 am
Still trying figure out what the point of this feature is suppose to help with.
After some reading it appears to be a quick short cut to update stats for new...
November 18, 2014 at 7:33 am
Dave62 (10/17/2014)
October 17, 2014 at 12:15 pm
Luis Cazares (10/1/2014)
Why are you truncating the log file? You're only affecting performance. You should define an appropriate size to fulfill your needs and prevent autogrowth with normal operations.
I would...
October 1, 2014 at 10:54 am
Viewing 15 posts - 1 through 15 (of 24 total)