Viewing 15 posts - 9,736 through 9,750 (of 19,560 total)
Nice question.
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
June 10, 2011 at 2:47 pm
GilaMonster (6/10/2011)
SanDroid (6/10/2011)
i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:
This is MCM level material. Planning...
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
June 10, 2011 at 2:46 pm
D.R. who needs D.R.?
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
June 10, 2011 at 2:30 pm
Michael Valentine Jones (6/9/2011)
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
June 10, 2011 at 2:28 pm
Lynn Pettis (6/10/2011)
SQLRNNR (6/9/2011)
Last minute trying to get the word out. We opened up S3OLV meeting to virtual this month.Info here: http://jasonbrimhall.info/2011/06/09/june-s3olv-update/
I had technical difficulties last night and couldn'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
June 10, 2011 at 2:24 pm
Last minute trying to get the word out. We opened up S3OLV meeting to virtual this month.
Info here: http://jasonbrimhall.info/2011/06/09/june-s3olv-update/
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
June 9, 2011 at 5:06 pm
sqldba_icon (6/9/2011)
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
June 9, 2011 at 4:10 pm
Yes there are comparison checks performed by SQL Server to ensure that the value is unique if you are inserting a value into a unique index. Performance ramifications will...
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
June 9, 2011 at 3:28 pm
sqldba_icon (6/9/2011)
Lowell (6/9/2011)
here's the full reference to Cast And Convert; it's good to read, it's something you end up using a lothttp://msdn.microsoft.com/en-us/library/ms187928.aspx
Select
convert(nvarchar(max),TheNTextColumn) AsColumnName
From TableName
I need 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
June 9, 2011 at 3:09 pm
GilaMonster (6/9/2011)
Steve Jones - SSC Editor (6/9/2011)
Plenty, at least until you threw him across the room.
I dunno. It's easy to forget there's a real person on the other end of...
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
June 9, 2011 at 1:12 pm
Steve Jones - SSC Editor (6/9/2011)
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
June 9, 2011 at 1:09 pm
Steve Jones - SSC Editor (6/9/2011)
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
June 9, 2011 at 1:06 pm
GSquared (6/9/2011)
Add "default" as a second parameter:Select * from fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_255.trc', default)
Thanks for covering Gus.
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
June 9, 2011 at 12:32 pm
Krasavita (6/9/2011)
This what I got:traceidpropertyvalue
112
12C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_255.trc
1320
14NULL
151
211
22NULL
23NULL
24NULL
251
Now try this
Select * from fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_255.trc')
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
June 9, 2011 at 12:13 pm
Check the default trace.
SELECT * FROM ::fn_trace_getinfo(default)
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
June 9, 2011 at 12:03 pm
Viewing 15 posts - 9,736 through 9,750 (of 19,560 total)