Viewing 15 posts - 10,006 through 10,020 (of 22,224 total)
You can't detach a database with users actively connected to it. You'll have to kick them off first. No choice there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2013 at 5:11 am
Brandie Tarvin (2/14/2013)
anthony.green (2/14/2013)
Brandie Tarvin (2/14/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2013 at 3:55 am
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 not. I have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2013 at 4:17 pm
Jeff Moden (2/13/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2013 at 9:38 am
Cadavre (2/13/2013)
So, the SQL Bits agenda has been released, anyone going? I'm planning on grabbing a Friday ticket tomorrow morning, but unsure about the Saturday.
I'm presenting on Saturday. I'll be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2013 at 8:17 am
Stats being out of date like that is only one possible cause of a spill, but yeah, that could be it. And yes, what you're seeing is SQL Server wants...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2013 at 8:09 am
Viewing 15 posts - 10,006 through 10,020 (of 22,224 total)