Forum Replies Created
Viewing 15 posts - 13,981 through 13,995 (of 22,224 total)
-
RE: Predicting backup size of the database
Ninja's_RGR'us (11/2/2010)
Grant Fritchey (11/2/2010)
Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Predicting backup size of the database
Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size a number of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Crazy Index Issue
I'd have to see the execution plans for both queries before I could hazard a guess. It might be that adding the index caused the query to recompile. It might...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Why/how/when Full Clustered Index Scan is preferred over Full Table Scan
vgv8 (11/1/2010)
The last bolded part seems to me in contradiction with "it’s a table scan in all but name".From this citation I can understand that Full CL-IX (Clustered Index)...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/31/2010)
Just noticed that I missed spotting a milestone. Better (a little) late than neverCongrats. You worked hard for that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: use log file
GilaMonster (10/30/2010)
Grant Fritchey (10/30/2010)
The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.Or put triggers on the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: use log file
The default trace does not store data manipulation calls. In order to track those you'll have to create your own server side trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: restrict log file size -sql server 2005
The more important question to ask is, why is your log growing? Do you have a database in Full Recovery mode, but you're not running backups? Do you have log...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: extended stored procedure
This is the Microsoft documentation. What are you looking for?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Update Statistics is Part of a Restore
Since the statistics are stored with the database (except in the case of an upgrade, as was mentioned), they will be moved with that database. This means, if the statistics...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Help with a locking process involving extended stored procedures
Then you'd probably be better off doing the integration some other way, call both databases from the app instead of one database from the other database, something along those lines.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: I am having problem in 2008 (RTM)
GSquared (10/29/2010)
Am I correct that this table does not have a clustered index nor a primary key?That seems to be what you're describing.
If so, that's probably a major part of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: I am having problem in 2008 (RTM)
parthi-1705 (10/29/2010)
Grant Fritchey (10/29/2010)
You're really naming all your columns, Col1, col2... Troubleshooting and developing against that should be a lot of fun.The Column name i have kept on my server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Back to the original purpose of this thread, my only response to this, once the clarification was in, is WTF?!?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: I am having problem in 2008 (RTM)
SELECT * FROM TableThis query will simply scan the table. So, performance is strictly up to the hardware. How fast are your disks? How fast is your CPU? That's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 13,981 through 13,995 (of 22,224 total)