Forum Replies Created
Viewing 15 posts - 17,311 through 17,325 (of 22,226 total)
-
RE: COPY_only Backup??
Yes you may.
It's simply another backup, but it doesn't affect the chain of log backups and differential backups which are based on the last full backup.
To use it, simply...
"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: ALLOW_PAGE_LOCKS vs DEADLOCKS vs REBUILD INDEX
Kalen is a lady.
According to BOL, An index can be rebuilt with ALLOW_PAGE_LOCKS set to off, but it can't be reorganized.
It's not recommended to mess with the locking mechanisms...
"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: What is the column naming convention when creating columns in a table?
Except when dealing with Oracle structures & data, we actually try to stay away from odd ball abbreviations. It's so much easier to understand what 'DeductibleRate' is versus 'DdltblRt.' Our...
"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?
Jeff, after you install the hand rails, you'll also need one of these:
"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 Database, Same Query, Different Server, VERY Different Query Cost
Statistics & data distribution yes, but CPU, memory and disk I/O are also taken into account (although not I/O speed). You also have to deal with parallelism as a factor....
"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 Database, Same Query, Different Server, VERY Different Query Cost
Costs are an estimated value base on a baseline machine from back in the 90's. They're extremely arbitrary and subject to all sorts of vagaries around the statistics of 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: problem in caching sp plans
That's a little bit fast. It's based on a cleanup process that starts with the complexity of the plan. The simpler the plan, the lower the complexity number, therefor 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: Problem With Adding FileStream To My DB
It still sounds like a permissions problem.
"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: Query is performing slow when sorted on datetime column
INT will sort faster then DATETIME but not radically faster. Have you updated the statistics on the index recently, maybe with a full scan. Is there a good data distribution...
"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: problem in caching sp plans
The procedure cache can and does change. Procedures age out of cache as they are not accessed. It's a pretty normal part of the process.
"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: Efficiency and scaling
If I understand the code and the explanation, I think you can change this to use a single pass through one cursor. Instead of a set of SELECT statements and...
"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: Call a stored procedure from a WHERE clause
Loading the output from a procedure into a temp table and then joining that temp table with your other tables is a good approach. As was noted, if you only...
"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: Problem With Adding FileStream To My DB
Does the account that SQL Server is running under have access to that drive and/or share? It sounds like a security issue.
"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?
Steve Jones - Editor (6/2/2009)
Whether it's right or wrong, I come down on the side of allowing authors to have a voice and make their position known. I like 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: Are the posted questions getting worse?
Roy Ernest (6/2/2009)
Grant, Bill says Hi back to you.. 🙂He wants to know if you still got your Fedora?? 😉
That thing made my head itch something fierce. It's gone.
"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 - 17,311 through 17,325 (of 22,226 total)