Viewing 15 posts - 9,991 through 10,005 (of 22,213 total)
You should be able to get all the answers to your questions from the Quest web site. It's all there.
February 25, 2013 at 7:33 am
The blog can show the stuff you're learning too. It doesn't just have to be "look at me, I'm awesome." In fact the posts that say "Hey, I ran into...
February 25, 2013 at 6:19 am
Jeff Moden (2/22/2013)
I've been up to my eyes with work and they only have SQL Server 2005 so I haven't even broken the surface on Extended Events. That explains...
February 22, 2013 at 1:54 pm
Instead of running XML queries against the server, a relatively high process event, I'd output the Extended Events to a file, then you can read that file from another server...
February 22, 2013 at 1:37 pm
You can't detach a database with users actively connected to it. You'll have to kick them off first. No choice there.
February 15, 2013 at 11:42 am
While those tools do have the VS shell, you'll still have to do a Visual Studio install to get the ASP.NET aspects installed.
February 15, 2013 at 11:41 am
ScottPletcher (2/15/2013)
I haven't been required to do a point-in-time recovery or tail-log backup for MONTHS. Depending on the environment, that may never be required of your job as DBA.
Certainly...
February 15, 2013 at 9:03 am
Always, always, always, contact Microsoft directly for licensing questions. It's a constantly shifting target. Plus you can negotiate deals. There's just no way a random stranger, even ones as informed...
February 14, 2013 at 6:04 am
Also check the ANSI connection settings on the two servers.
Let's see, cost threshold for parallelism, the max degree of parallelism, umm... The stuff already mentioned.
February 14, 2013 at 6:02 am
The entire query is compiled when you execute it. But the path through the actual data will follow the CASE statement.
But, this example shows the problem with using this approach....
February 14, 2013 at 5:11 am
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
February 14, 2013 at 4:54 am
Ratheesh.K.Nair (2/13/2013)
Thanks Anthony.They want real time data..Any way??
Wait, they want real time static data? That doesn't make any sense.
February 14, 2013 at 4:47 am
Brad's books is extremely good. You should also check out Thomas LaRock's book DBA Survivor. It covers the job from a different point of view.
February 14, 2013 at 4:41 am
rodjkidd (2/14/2013)
Grant Fritchey (2/13/2013)
Dave Ballantyne (2/13/2013)
rodjkidd (2/13/2013) Remember stitting there with a bad, bad hangover, just hoping I didn't throw up 🙂
That sums up the sqlbits experience 😉
God I hope...
February 14, 2013 at 4:05 am
SQLSACT (2/13/2013)
GilaMonster (2/13/2013)
Why would you see a tempDB allocation when something's not spilling to TempDB?
From Grant:
All temporary tables (hash/work tables, temp tables, table variables) are written to disk as well...
February 14, 2013 at 3:55 am
Viewing 15 posts - 9,991 through 10,005 (of 22,213 total)