Forum Replies Created
Viewing 15 posts - 14,056 through 14,070 (of 22,219 total)
-
RE: Wierd one..
It sounds like a parameter sniffing issue. A quick fix would be to recompile the procedure on prod and see if the plan changes.
"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 Moden (10/21/2010)
Grant Fritchey (10/20/2010)
Jeff Moden (10/20/2010)
Paul White NZ (10/20/2010)
GSquared (10/20/2010)
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages 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: Are the posted questions getting worse?
Jeff Moden (10/20/2010)
Paul White NZ (10/20/2010)
GSquared (10/20/2010)
I definitely don't. Has all the disadvantages of nested sets and the disadvantages of adjacency, without the advantages of either. It's a..."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?
LutzM (10/20/2010)
Is it just because I'm in a bad mood today or why do I have the feeling that todays questions are more demanding with even less effort than on..."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
Or, would it be
SELECT * FROM TABLE WHERE SK = 1 AND Flag = 1I'm confused too."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: To debug sql stored proceudres
Please don't post to multiple locations. It just messes up the conversation.
There are also responses over here.
"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: Debugging SQL server Stored Procedures
What are you trying to do?
Simply debugging the procedure, which means validating that it runs correctly and does what is requested of it, just requires access to the database 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: Recommended reading/books?
Oh, and start learning PowerShell. I'd start with Don Jones book, PowerShell 2.0, TFM.
"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: Recommended reading/books?
I'd get two of the Inside SQL Server 2008 books, T-SQL Querying by Itzik Ben-Gan and Internals by Kalen Delaney. The vast majority of what you need to know is...
"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: Maintenance Plans in SQL 2005
GilaMonster (10/19/2010)
Grant Fritchey (10/19/2010)
Just a side note, a Microsoft consultant told me that all I needed to use was the checksums for validation of the backup, but I still prefer..."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?
Brandie Tarvin (10/19/2010)
I would just like to let everyone know that I live very green.My sheets are green, my clothes are green, my food is green, my cats are green......
"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: Create Hidden Trace / Mask Trace
mitchismoney (10/19/2010)
The user doesn't have access to profiler. Will revoking access to trace work even DBCC Traceon? I didn't think you could deny specific DBCC commands?Thanks
You can't deny...
"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: How to get the Internal ID from a ROW
This is not something I've tried before. When I tried to replicate what you said happens, with duplicate rows and editing them using SSMS, I got this error:
This is a...
"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: Maintenance Plans in SQL 2005
Brandie, EXCELLENT point on testing backups. That is something we do, but I forgot to mention it. It's a must.
Just a side note, a Microsoft consultant told me that all...
"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: Urgent SQL Linked Server Query - Cannot see ms access linked tables.
If you can't see the tables, it's probably 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
Viewing 15 posts - 14,056 through 14,070 (of 22,219 total)