Viewing 15 posts - 6,991 through 7,005 (of 19,560 total)
It felt good to be out of the rain
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
January 26, 2012 at 9:28 am
KWymore (1/26/2012)
Nice question. And this is why we always declare lengths for variable data types.
Agreed
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
January 26, 2012 at 8:45 am
Brandie Tarvin (1/26/2012)
Daniel Bowlin (1/26/2012)
I am declaring a lyric day."The cat's in the cradle and the silver spoon..."
Everybody's eating there today at noon.
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
January 26, 2012 at 8:42 am
Hugo Kornelis (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
I didn't see the note about starting the shrink and changing the files.I'll update the question to clarify.
<nitpick>
I still disagree with 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
January 25, 2012 at 4:14 pm
Also, take a look at this article for a process to create in order to capture this information automatically in the future.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
January 25, 2012 at 12:22 pm
Daniel Bowlin (1/25/2012)
Brandie Tarvin (1/25/2012)
pinwheelferris wheel
flywheel
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
January 25, 2012 at 9:42 am
GilaMonster (1/24/2012)
SQL Kiwi (1/24/2012)
GilaMonster (1/24/2012)
Oooh, a palindrome! Nice.It's also the first five binary digits of 10001001 - a number I seem to recall has special significance to you 🙂
Yes, I...
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
January 24, 2012 at 5:53 pm
Thanks yet again Steve.
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
January 24, 2012 at 8:39 am
mutation
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
January 24, 2012 at 8:33 am
LutzM (1/23/2012)
SQLRNNR (1/23/2012)
LutzM (1/23/2012)
Why don't you use the DATEDIFF() function?What's the goal you're trying to achieve?
That is funny - same question (goal), same time - different sources.
If I wouldn't be...
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
January 23, 2012 at 4:51 pm
LutzM (1/23/2012)
Why don't you use the DATEDIFF() function?What's the goal you're trying to achieve?
That is funny - same question (goal), same time - different sources.
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
January 23, 2012 at 4:41 pm
What is your end goal?
What should the data look like after performing this calculation?
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
January 23, 2012 at 4:39 pm
Revenant (1/23/2012)
SQLRNNR (1/23/2012)
Ray K (1/23/2012)
L' Eomot Inversé (1/23/2012)
SQLRNNR (1/23/2012)
facetfacetious
faucet
Bois de l'eau
Mauvais conseil.
Ca depend
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
January 23, 2012 at 2:31 pm
or the following
declare @Date date = GETDATE()
select @Date
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
January 23, 2012 at 2:29 pm
Ray K (1/23/2012)
L' Eomot Inversé (1/23/2012)
SQLRNNR (1/23/2012)
facetfacetious
faucet
Bois de l'eau
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
January 23, 2012 at 2:03 pm
Viewing 15 posts - 6,991 through 7,005 (of 19,560 total)