Viewing 15 posts - 16,441 through 16,455 (of 22,219 total)
Flat out, it depends. I get something from Jeff, Gail, Lynn, the usual suspects, I will review it and test it, but I'll generally assume it's right. I get something...
"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
September 25, 2009 at 6:50 am
Roy Ernest (9/24/2009)
"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
September 25, 2009 at 5:22 am
It can be useful for troubleshooting. You can see the transactions by name if you select sys.dm_tran_active_transactions.
"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
September 24, 2009 at 12:22 pm
You'll have to walk through the database using some type of cursor and calls to DBCC SHOW_STATISTICS in order to look at the database statistics.
As already stated, unless you put...
"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
September 24, 2009 at 11:11 am
Roy Ernest (9/24/2009)
"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
September 24, 2009 at 7:34 am
I'd strongly suggest taking SilverFox's second suggestion and use sys.dm_index_physical_stats. There's more information to be had in a clearer fashion than from the older showcontig statement.
"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
September 24, 2009 at 6:41 am
Silverfox (9/24/2009)
"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
September 24, 2009 at 6:39 am
Yes
"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
September 24, 2009 at 5:58 am
espanolanthony (9/23/2009)
but Chim, i want to grant on all the stored procedures. and by that process i can grant only one by one stored procedures.
You can grant execute to a...
"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
September 24, 2009 at 5:57 am
I don't think there's any tools out there that will do quite what you're looking for. You can get bits & pieces of it. For example, a good ER diagramming...
"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
September 24, 2009 at 5:53 am
Bob Hovious 24601 (9/23/2009)
AllRIGHT! Extra effort paid off. I just got approval to go to PASS. 😀 😀 😀
Excellent. See you...
"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
September 24, 2009 at 5:34 am
You're stepping into a minefield of sorts here. This is the long-standing discussion between natural keys and artificial keys. I don't want to kick up too much mud, so I'll...
"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
September 23, 2009 at 1:10 pm
If you're planning on storing the entire file, I wouldn't recommend using SQL Server. Instead, I'd store it on the file system. If you're using 2008, you could use 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
September 23, 2009 at 1:06 pm
Without bringing in other langauges such as PowerShell or C#, you're probably doing the best you can, especially when you consider that gathering information on 2008 is really different from...
"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
September 23, 2009 at 8:41 am
jeardilam (9/23/2009)
while (select id_promotionSub FROM dbo.sipFTdataStage)=5
begin
...
"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
September 23, 2009 at 8:40 am
Viewing 15 posts - 16,441 through 16,455 (of 22,219 total)