Viewing 15 posts - 17,356 through 17,370 (of 22,219 total)
Logs and log backups don't have anything to do with the data file groups. If the third group is read only, then no log activity will be recorded against 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
May 28, 2009 at 6:40 am
There is no SELECT trigger. The best way is what you already have planned, collect the data through a server-side trace (which you can use Profiler to set up). Depending...
"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
May 28, 2009 at 6:37 am
Attention to detail.
Which server are you connected to? You might want to know before you run that drop table command.
Does this UPDATE query have a WHERE clause? Be sure before...
"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
May 28, 2009 at 6:35 am
Pradyothana Shastry (5/27/2009)
Statistics will be updated automatically after index rebuild
Right, all this echoing is starting to get creepy. You can stop now.
"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
May 27, 2009 at 5:32 pm
And because I can...
10 bottles of beer on the wall, 10 bottles of beer...
"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
May 27, 2009 at 5:30 pm
GilaMonster (5/27/2009)
Is there an echo in here ...echo in here... ...echo in here... ?http://www.sqlservercentral.com/Forums/FindPost724259.aspx
http://www.sqlservercentral.com/Forums/FindPost723631.aspx
Well now that's just strange. What the heck?
"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
May 27, 2009 at 5:26 pm
You may have to edit the SSIS package the import/export wizard creates.
"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
May 27, 2009 at 1:28 pm
Don't migrate the timestamp column. It will generate on it's own.
"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
May 27, 2009 at 12:57 pm
Then you can probably get what you need by querying the DMV's.
"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
May 27, 2009 at 12:20 pm
Yep. I just tried the update. It didn't seem to affect things at all. It sure sounds like the PK was not defined as the script you supplied. I can't...
"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
May 27, 2009 at 11:53 am
I agree. First option would be to query the DMV's to see what has been run. However, if you wanted to know what was run yesterday or last week, 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
May 27, 2009 at 11:12 am
Jeffrey Williams (5/27/2009)
If...
"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
May 27, 2009 at 11:05 am
Tom Brown (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?We have a working title!
Chapter headings anyone?
And evidently a volunteer for the head author position. Well done.
"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
May 27, 2009 at 8:19 am
Alvin Ramard (5/27/2009)
Bob Hovious (5/27/2009)
What's an index?It's one of your fingers.
Oh, I thought that was a digit. All this computer-ese is so confusing.
"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
May 27, 2009 at 8:16 am
Roy Ernest (5/27/2009)
Hey Grant, I did not know that you brew your own beer... :w00t:
Actually, I haven't for about a year and a half. I miss it, but between writing...
"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
May 27, 2009 at 8:07 am
Viewing 15 posts - 17,356 through 17,370 (of 22,219 total)