Viewing 15 posts - 9,691 through 9,705 (of 22,219 total)
If you don't have monitoring in place to track disk space and disk usage, there's no way to tell. Nothing within SQL Server will automatically remember that on Jan 1...
"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
July 31, 2013 at 6:53 am
SQLRNNR (7/30/2013)
Koen Verbeeck (7/30/2013)
SQLRNNR (7/29/2013)
L' Eomot Inversé (7/29/2013)
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
I...
"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
July 30, 2013 at 3:45 pm
Welcome!
Keep your hands and feet inside the vehicle at all times and enjoy the ride.
"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
July 30, 2013 at 8:19 am
Bhaskar.Shetty (7/30/2013)
I am facing a weird problem since couple of days, When we tried to execute the any SP (Randomly) sometimes throws the error "The definition of...
"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
July 30, 2013 at 8:18 am
No, you'd need to script it. But, if you have a fairly consistent naming or storage mechanism you should be able to script the scripting, write dynamic T-SQL to build...
"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
July 30, 2013 at 8:14 am
I would not assume they're identical in all respects. You need to identify specifically why the query is running slowly. I'd start with sys.dm_exec_requests. That will show you if the...
"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
July 30, 2013 at 8:05 am
A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but you still...
"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
July 30, 2013 at 8:04 am
Spools are a way for the query engine to store data, either for reusing it, or for rollbacks (other situations too, imagine where it might need to keep stuff for...
"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
July 30, 2013 at 8:01 am
I'm cool with anyone handling backups. As long as they get done and (the kicker) as long as we can successfully restore them in a timely manner. If it takes...
"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
July 30, 2013 at 7:58 am
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time, everywhere.
"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
July 29, 2013 at 12:23 pm
HowardW (7/29/2013)
Grant Fritchey (7/23/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
July 29, 2013 at 9:14 am
No worries. Which user group was it?
"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
July 24, 2013 at 1:20 pm
They have relaunched the project and something should be coming out ... soon? I don't have any dates or date estimates for you. Sorry. But, I think, possibly, this fall....
"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
July 24, 2013 at 1:11 pm
In general, partitioning is not a great mechanism for improving query performance.
Without seeing the query or the execution plan, I'm only guessing.
It sounds like the order in which the...
"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
July 24, 2013 at 1:08 pm
Be careful with the UDF. An in-line UDF is fine, but a multi-statement table valued UDF could lead to serious performance bottlenecks.
"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
July 24, 2013 at 5:06 am
Viewing 15 posts - 9,691 through 9,705 (of 22,219 total)