Viewing 15 posts - 8,176 through 8,190 (of 19,560 total)
Very peculiar - I am getting the same issue as well - just one server - 2008 10.0.4272
Logged in with account that is sa.
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
October 18, 2011 at 11:18 pm
If your test data is truly too close to real data, then it probably should be secured just like prod. If you can't obfuscate it efficiently enough, then secure...
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
October 18, 2011 at 10:31 pm
Jeff Moden (10/18/2011)
Mark-101232 (10/18/2011)
WITH AllAlpha(Letter) AS (
SELECT CHAR(ASCII('A')+N)
FROM dbo.Tally
WHERE N BETWEEN 0 AND 25)
SELECT (SELECT c.Letter AS "text()"
...
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
October 18, 2011 at 10:04 pm
Well, we do it as a team effort. The DBAs request sizes from the SAN, the SAN admin presents the LUN for use by the OS, and then 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
October 18, 2011 at 9:29 pm
Jeff Moden (10/18/2011)
jshahan (10/18/2011)
Maybe someone sugested this and I missed it but just convert getdate() to a string and back to a date.select CONVERT(datetime,(convert(char(10),getdate(),101))) as Today
Hopefully, you'll change your mind...
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
October 18, 2011 at 9:26 pm
Thanks for the 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
October 18, 2011 at 9:07 pm
Steve Jones - SSC Editor (10/18/2011)
and we're talking about (bleep)ing pants.
I mean listen, we're sitting here talking about (bleep) pants,
not...
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
October 18, 2011 at 8:52 pm
Sean Lange (10/18/2011)
Oh look at the pants, time to go home.
All pants are off!!
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
October 18, 2011 at 4:08 pm
Ninja's_RGR'us (10/18/2011)
....Filling in the pants to get it up to a nice round number.
:w00t::hehe:
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
October 18, 2011 at 4:07 pm
Look at the following thread for a nice example on the quirky update.
http://www.sqlservercentral.com/Forums/Topic936773-338-1.aspx
This should help with what you need.
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
October 18, 2011 at 3:54 pm
Nice real world example. Thanks.
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
October 18, 2011 at 3:51 pm
ALZDBA (10/18/2011)
So, that's what do you get when suffering a SQLServer overdose at SQLpass ... Pantoriosis😀
G'night y'all
Nope - it would be Multiple Pantosis
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
October 18, 2011 at 3:48 pm
David Moutray (10/18/2011)
SQLRNNR (10/17/2011)
Nah - just go with Itziks book. :-D:-D:-D:-D
Do exercise caution, however. If you attempt to read too much of Itzik Ben-Gan in one go, your head...
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
October 18, 2011 at 3:12 pm
Booger: "Big deal! Did you get in her pants? "
Oh wait, we were supposed to replace a word with pants 😀
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
October 18, 2011 at 2:20 pm
In the Pants of Life
It's the wheel of fortune
It's the leap of faith
It's the band of hope
Till we find our place
On the path unwinding
In the Pants , the Pants 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
October 18, 2011 at 2:18 pm
Viewing 15 posts - 8,176 through 8,190 (of 19,560 total)