Forum Replies Created
Viewing 15 posts - 11,671 through 11,685 (of 22,219 total)
-
RE: Restoring DB
And the answer is still the same.
"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 is my SELECT query slower when the table is indexed?
Execution plans are XML saved as a .SQLPLAN file. You can generate them, save them, and attach them, as is. All the data within will be transmitted. The preferred method...
"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: PRIMARY Clustered vs NonClustered
The question I'd ask is not which is faster for the insert, but which supports the SELECT queries better. You're going to load once an hour/day/week/year and then in between...
"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: SQL 2005 PERFORMANCE
Before we talk monitoring, let's validate your nightly process. You recreate your indexes and then update the stats? Is that right? If so, you might be hurting performance right there....
"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: Clustored indexes and the direction of the sort
Honestly, I doubt there's a single right answer to this. I don't know of anyone who, as a matter of routine, sets their identity values to be DESC. But if...
"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: Sql Query
There's Joe Sack's TSQL Recipe's. It's nothing but scripts and how to write them.
"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: Database Maintenance job failing contineously?
Without more detail, it's hard to know for certain. For example, updating stats is good, but rebuilding an index also updates the stats, and with a full scan, not sampled....
"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?
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
What is this query plan operator?It depends. It could be a hash join, hash aggregate, flow distinct, or a union...
Really? Looks like a car going into...
"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: Simple Equal not returning records but Like condition is
It's highly unlikely that an index would change the results of a query. It looks like you have an extra space at the end of the line, which is why...
"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: Same query gives different number of records
Hard to know without seeing the query and knowing something about the data. Assuming no changes to the data and a well structured query, you should see the same data...
"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: New on Powershell
I'd pick up a book called Powershell in a Month of Lunches. That'll get you going quick. Same author has a more detailed book, PowerShell TFM. Get the 2.0 version.
"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: Taking cold backups (and scheduling it) in SQL Server?
I would absolutely advocate against this with every breath I took, but yes, you could shut down the server, then copy the database and log files, then restart the 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: Vendor suggesting their issue is a limitation of sql server
kstjacques (10/23/2011)
Grant Fritchey (10/23/2011)
I just hope the vendor isn't one near & dear to my heart.
Yeah, there are lots of reasons to use a third party backup method. For example,...
"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: OpenQuery Performance help needed urgently
What are you using the 68k records for? That's going to take a while to move into SQL Server... a long while. If you're doing an import you might want...
"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?
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Now?
😀
"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 - 11,671 through 11,685 (of 22,219 total)