Viewing 15 posts - 9,376 through 9,390 (of 19,560 total)
SQLkiwi (7/18/2011)
The Dixie Flatline (7/18/2011)
And also...
select (ABS(@test)+@test)/2 as resultNeat!
Agreed - good thinking there Bob
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
July 19, 2011 at 5:17 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
July 19, 2011 at 5:03 pm
When is a table not a table?
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
July 19, 2011 at 5:03 pm
sql2k8 (7/19/2011)
SELECT
[Time],
cast(cast([Time]/60 as int) as varchar) + ':' + CAST(CAST([Time]%60 as int) as...
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
July 19, 2011 at 5:02 pm
I hate smelly code.:sick:
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
July 19, 2011 at 4:56 pm
Here is the technet article on enabling agent xps
http://technet.microsoft.com/en-us/library/ms178127.aspx
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
July 19, 2011 at 4:53 pm
The remaining question you asked is about who buys the license. It seems that you are aggregating data for clients and using your own app to interface with 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
July 19, 2011 at 4:46 pm
11Gb is not very big. If you want to create a new file, that is up to you. If you do, I would consider placing the new file...
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
July 19, 2011 at 4:36 pm
Have you enabled a mail profile for SQL Agent?
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
July 19, 2011 at 4:35 pm
bopeavy (7/19/2011)
SQLRNNR (7/19/2011)
Revenant (7/19/2011)
--------------------------------------------------------------------------------
Steve Jones - SSC Editor (7/19/2011)
--------------------------------------------------------------------------------
Dentist
Ugh
Draft in the wallet
More like Black Hole
Oh---Root Canal!
That was mine last week 😉
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
July 19, 2011 at 10:34 am
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
July 19, 2011 at 10:29 am
Steve Jones - SSC Editor (7/19/2011)
congrats, Mr Moden!
Yes - well deserved.
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
July 19, 2011 at 10:27 am
WayneS (7/19/2011)
Gianluca Sartori (7/19/2011)
Ninja's_RGR'us (7/19/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
Wow Jeff must make a nice santa...
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
July 19, 2011 at 10:26 am
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
Now some of us get to see the man behind 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
July 19, 2011 at 10:25 am
Revenant (7/19/2011)
Steve Jones - SSC Editor (7/19/2011)
DentistUgh
Draft in the wallet
More like Black Hole
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
July 19, 2011 at 10:23 am
Viewing 15 posts - 9,376 through 9,390 (of 19,560 total)