Forum Replies Created
Viewing 15 posts - 6,376 through 6,390 (of 22,228 total)
-
RE: How to get number of execution in specific time-not from first
The clue is the start and end offset. They are statements in a single batch. The queries in a batch are stored seperately, but the batch, especially in the sql...
"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: SELECT COUNT(*) vs DMVs to get row count
As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is COUNT. Everything I...
"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 track SP's to tempdb usage
I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries, you can just add them in...
"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 would I be able to capture sessions who modify a table with the details modified in the table
You're describing Change Data Capture.
"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: ? A select top1 within a select ?
Since no one else pointed it out, I sure will:
WHERE (dbo.CLI.CLITYPE LIKE '%A%') AND (dbo.SVAC.PROGNO LIKE '%286%' ORdbo.SVAC.PROGNO LIKE '%288%' OR
dbo.SVAC.PROGNO LIKE '%289%')
That is going to lead to some...
"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: MS Sql server 2008R2 Upgrade Advisor confusion
No. Unable to connect to server suggests that you're trying to connect to the wrong server, are running the Upgrade Advisor from a login that doesn't have permission to 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: Deadlock Issue SQL Server 2008 R2
There's not enough here. These are part of a greater process. That other process has other statements. You need to determine the order in which these statements are occurring. This...
"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 need a guideLine for Standard Database Design
There are simple references for normalization all over the place online. Just do a search and you'll find one.
As to a guide on database design, I'm not aware of 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?
Brandie Tarvin (4/10/2015)
Luis Cazares (4/10/2015)
Grant Fritchey (4/10/2015)
Brandie Tarvin (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever...
"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 (4/10/2015)
Grant Fritchey (4/10/2015)
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:Not that I've ever been that high, but I'm putting...
"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?
Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:
"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: "normal" non-clustered index vs INCLUDE index
Lynn Pettis (4/10/2015)
Grant Fritchey (4/10/2015)
Lynn Pettis (4/10/2015)
RonKyle (4/10/2015)
but by avoiding key lookups, or worse table/index scans
assuming the table is not a heap (which it shouldn't be, right?), why would it...
"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: "normal" non-clustered index vs INCLUDE index
Lynn Pettis (4/10/2015)
RonKyle (4/10/2015)
but by avoiding key lookups, or worse table/index scans
assuming the table is not a heap (which it shouldn't be, right?), why would it (at least as 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: "normal" non-clustered index vs INCLUDE index
RonKyle (4/10/2015)
If I can add two include columns to an index and get a query that runs 10 times a second down from 400ms to 10ms, you bet I'm going...
"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: "normal" non-clustered index vs INCLUDE index
RonKyle (4/10/2015)
Interesting. I haven't personally made much use of include indexes since they do make the indexes bigger and I'm not convinced the performance gains are significant. I..."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 - 6,376 through 6,390 (of 22,228 total)