Viewing 15 posts - 3,286 through 3,300 (of 19,560 total)
spitball
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
March 31, 2014 at 8:37 am
Eric M Russell (3/31/2014)
If one of my daughters expressed a desire to pursue a career in technology, I would encourage her with no reservations.
I would do the same. ...
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
March 31, 2014 at 8:37 am
I would check that month old backup and confirm it is corruption free. If they aren't taking regular backups, I'd guess they didn't perform routine checkdb's. They very...
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
March 31, 2014 at 8:21 am
Koen Verbeeck (3/31/2014)
sagar.vij1989 (3/31/2014)
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
March 31, 2014 at 8:16 am
sestell1 (3/31/2014)
The answer depends on the server role memberships of the login.
Since no information provided regarding the login's...
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
March 31, 2014 at 8:12 am
Steve Jones - SSC Editor (3/28/2014)
Jeff Moden (3/28/2014)
GilaMonster (3/28/2014)
Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:Grant *is* the booth 'babe' 🙂
Heh... especially on kilt day. 😀
You have six months,...
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
March 28, 2014 at 11:02 am
Michael Valentine Jones (3/28/2014)
Luis Cazares (3/28/2014)
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
March 28, 2014 at 10:08 am
Luis Cazares (3/28/2014)
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
March 28, 2014 at 10:05 am
JAZZ Master (3/28/2014)
Revenant (3/28/2014)
Ed Wagner (3/28/2014)
Kurt W. Zimmerman (3/28/2014)
SQLRNNR (3/28/2014)
Ed Wagner (3/28/2014)
RowRoe
Wade
Deep
Purple
Rain
Cry
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
March 28, 2014 at 9:09 am
Andy Warren (3/28/2014)
Free, agree the answers are contradictory...yet correct! I probably pushed the boundaries of fairness there.
Yeah probably just a bit. But based on the question criteria it could...
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
March 28, 2014 at 8:03 am
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
I'm afraid that this database is full of these pieces 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
March 28, 2014 at 7:51 am
Ed Wagner (3/28/2014)
Row
Roe
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
March 28, 2014 at 7:23 am
Greg Edwards-268690 (3/27/2014)
Steve Jones - SSC Editor (3/27/2014)
For your Thur entertainment: http://www.red-gate.com/products/dba/dba-bundle/entrypage/about-the-dba-team?utm_source=ssc&utm_medium=displayad&utm_campaign=sqldbabundle&utm_term=steve_videoRide'm Cowboy! :w00t:
Yeehaw
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
March 27, 2014 at 11:25 am
See if this will work for you
DECLARE @DateC DATETIME = '2014-03-27 3:51:08.997PM'
,@TimePart VARCHAR(20)
SET @TimePart = CONVERT(VARCHAR(20),CAST(DATEADD(HOUR,5,@DateC) AS TIME),100)
/* AMPM format */
SELECT CONVERT(VARCHAR,CONVERT(DATE, @DateC)) + ' ' + CONVERT(VARCHAR,@TimePart)
/* 24hr format...
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
March 27, 2014 at 11:10 am
below86 (3/27/2014)
Steve Jones - SSC Editor (3/27/2014)
below86 (3/27/2014)
I know this may not be what you meant by "The first is willfully taking part in any illegal activity.". But what...
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
March 27, 2014 at 9:22 am
Viewing 15 posts - 3,286 through 3,300 (of 19,560 total)