Forum Replies Created
Viewing 15 posts - 13,981 through 13,995 (of 22,227 total)
-
RE: Are the posted questions getting worse?
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories...
"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: Election Day
I agree. Every US citizen should go and vote.
And everyone should go and vote.
And then go and vote again[/url].
Specifically, support our local Gila[/url] Monster[/url] or PowerShell FTW[/url].
"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: Election Day
Nelson Williams-487553 (11/2/2010)
I find that irresponsible. Here we are on the government created Internet engaging in the free exchange of ideas and you don't want to take part.I think...
"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
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
Viewing 15 posts - 13,981 through 13,995 (of 22,227 total)