Grant Fritchey

Forum Replies Created

Viewing 15 posts - 6,376 through 6,390 (of 22,226 total)

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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:40 am

#1790344
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:36 am

#1790342
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%' OR
dbo.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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:35 am

#1790341
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:32 am

#1790340
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:29 am

#1790339
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 11, 2015 at 4:22 am

#1790338
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 12:33 pm

#1790260
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 12:14 pm

#1790251
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 11:27 am

#1790247
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 11:23 am

#1790245
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 10:34 am

#1790239
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 10:33 am

#1790238
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 8:48 am

#1790195
RE: Connection string that works for SQL Server 2012

Pretty sure this is not needed for a normal connection:AttachDbFilename=C:\path\App_Data\db.mdf
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 5:51 am

#1790120
RE: SQl to find Primary key table name and field name of a foreign key

You want to use the information_schema views to look for that type of information. Here's an article[/url] telling all about how they work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

April 10, 2015 at 5:50 am

#1790119

Viewing 15 posts - 6,376 through 6,390 (of 22,226 total)