Viewing 15 posts - 15,301 through 15,315 (of 19,560 total)
Lynn Pettis (4/5/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 7:49 pm
Capitalization of SQL Server should be consistent throughout.
I think I would also reword the questions that say "this certification" to " a middle tier certification."
Some verbiage at the beginning to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 7:46 pm
dma-669038 (4/5/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 7:26 pm
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
I would also enjoy neural computing. I could get a lot more done just by thinking it.Seems like a foolish risk. 😛
That depends on what it is...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 7:25 pm
ritu.thatola (4/5/2010)
I have to rewrite the query for SQL server 2005
when I try to run this sql in SQL...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 7:18 pm
WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
dma-669038 (4/5/2010)
WayneS (4/5/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 6:29 pm
The hostname can also be returned back into this query. That information is returned by fn_trace_gettable.
This would change the query as follows:
SELECT I.NTUserName,I.loginname,I.SessionLoginName,I.databasename,Min(I.StartTime) as first_used
,Max(I.StartTime) as last_used,S.principal_id,S.sid,S.type_desc,S.name,EC.client_net_address,I.HostName
FROM sys.traces T...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 6:27 pm
dma-669038 (4/5/2010)
WayneS (4/5/2010)
dma-669038 (4/5/2010)
WayneS (4/5/2010)
dma-669038 (4/5/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 6:17 pm
ritu.thatola (4/5/2010)
I couldn't get your comment "Just make changes as appropriate to the commented section. "
It would be great If you can rewrite the whole query. I don' know...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 6:12 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 6:00 pm
WayneS (4/5/2010)
dma-669038 (4/5/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 5:59 pm
There is no good reason to put up with persistent lying. I certainly agree there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 5:48 pm
This should be enough to get you going.
FROMtblVoucherDetails IDETAIL
Inner Join tblVoucherGroup PACKAGE
On Package.RegionID = IDetail.RegionID
AND IDETAIL.VoucherNumber = PACKAGE.VoucherNumber
AND IDETAIL.PackageID = PACKAGE.GroupID
/*Inner Join tblChargeType CHARGE
On Charge.ChargeTypeID *= Idetail.ChargeTypeID...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 5:47 pm
Jeff Moden (4/5/2010)
I guess that's reasonable. Thanks for the feedback, Jason.
NP.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 5:38 pm
Jeff Moden (4/5/2010)
Tom.Thomson (4/5/2010)
who are prepared to lie about how much testing they have done because they think they will get away with it.
Heh... I love it when they...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 5:28 pm
Viewing 15 posts - 15,301 through 15,315 (of 19,560 total)