Viewing 15 posts - 511 through 525 (of 19,560 total)
JustMarie (4/21/2016)
Brandie Tarvin (4/21/2016)
Eirikur Eiriksson (4/21/2016)
Brandie Tarvin (4/21/2016)
Luis Cazares (4/21/2016)
BLOB_EATER (4/21/2016)
Luis Cazares (4/21/2016)
Brandie Tarvin (4/21/2016)
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 21, 2016 at 10:31 am
WayneS (4/20/2016)
Ed Wagner (4/19/2016)
SQLRNNR (4/19/2016)
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?Do it!
Are you thinking something...
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 20, 2016 at 10:13 am
Personally, this strikes me as more interesting!
/* Version number binary from daily registy */
DECLARE @VERSION_STRING VARBINARY(max) = 0x6E7976777926807C71767771798078697977337C35778938398D3B8B8F80408F9594848597949C8E9B978F929293A2A5A05253A19A9AA6999E9FA05CA1B0A4B261A3;
--DECLARE @VERSION_STRING VARBINARY(max) = 0x4D5544532556564C5B504C552D675B;
/* Inline Tally for parsing the...
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 19, 2016 at 3:42 pm
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?
Do it!
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 19, 2016 at 10:16 am
Steve Jones - SSC Editor (4/15/2016)
About to head off to SQL Saturday Phoenix. Anyone else going?
See ya 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 15, 2016 at 12:24 pm
GilaMonster (4/15/2016)
Brandie Tarvin (4/15/2016)
BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my...
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 15, 2016 at 9:32 am
My sympathy to the loss of your database.
Like the others, I really do hope you a) have a backup and b) can convince the boss to hire a dba.
Three days...
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 15, 2016 at 9:17 am
Sean Lange (4/14/2016)
Grant Fritchey (4/14/2016)
Sean Lange (4/14/2016)
Oh that's right. It should be
;select
BURN IT WITH FIRE!!!!
Of course you do realize that all the same people that still start a cte with...
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 14, 2016 at 4:41 pm
jeff.mason (4/14/2016)
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Maybe some of you should write some questions to help people...
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 14, 2016 at 4:24 pm
Luis Cazares (4/14/2016)
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo...
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 14, 2016 at 4:23 pm
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
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 14, 2016 at 10:25 am
jasona.work (4/14/2016)
SQLRNNR (4/13/2016)
N' WITH PASSWORD = 0x' +
...
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 14, 2016 at 10:03 am
This is basically the means that I use now instead of revlogin
N' WITH PASSWORD = 0x' +
...
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 13, 2016 at 1:36 pm
jasona.work (4/13/2016)
You don't know about handy things like the SSIS task "Transfer Jobs" and "Transfer Logins"...
Thankfully I came across those today,...
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 13, 2016 at 11:56 am
SQLBill (4/12/2016)
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 12, 2016 at 10:58 pm
Viewing 15 posts - 511 through 525 (of 19,560 total)