Viewing 15 posts - 7,576 through 7,590 (of 19,560 total)
Bru Medishetty (12/12/2011)
Have you tried this ? http://technet.microsoft.com/en-us/library/ms190757.aspx
Hey Bru, where have you been? Long time no see!
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
December 12, 2011 at 7:16 pm
Thanks Tom.
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
December 11, 2011 at 2:19 pm
Hubbard
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
December 11, 2011 at 2:13 pm
L' Eomot Inversé (12/10/2011)
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
To infinity and...
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
December 10, 2011 at 9:53 am
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
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
December 10, 2011 at 9:41 am
You can't restore a 2008 database on SQL 2005.
If you must get the data from one to the other, you will need to import it (dts, ssis, redgate data compare).
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
December 8, 2011 at 11:20 pm
Surprised to see this one. It was only a few months ago we had one just like it (IIRC).
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
December 8, 2011 at 11:19 pm
Of course there is also the other way of doing it:
SELECT CONVERT(CHAR(10),GETDATE(),101)
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
December 8, 2011 at 11:15 pm
Must you have the slashes or would this work?
SELECT CONVERT(DATE,GETDATE())
The output of that is a DATE format rather than a string and it is in format of yyyy-mm-dd
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
December 8, 2011 at 11:13 pm
You should also watch the SSIS forums here and try to create the solutions for the questions posed. You will need to get some practice 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
December 8, 2011 at 10:39 pm
Revenant (12/8/2011)
I suppose, Tom, you noticed that the message says 32,766, not 32,767.
Is that because it is counting model in the total? So are there 32766 databases in addition...
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
December 8, 2011 at 10:35 pm
There are many improvements in SQL 2012. It will be out early 2012.
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
December 8, 2011 at 10:33 pm
Keep visiting SSC and try to solve some of the problems in the forums.
Reading List:
http://www.amazon.com/Official-Server-Certified-Master-Readiness/lm/R3RB13PQ7D8TKB
The list has some heavy duty stuff in it, but it is well worth learning.
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
December 8, 2011 at 10:30 pm
GilaMonster (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Yup, very much so. Confirms my opinion that you need to learn nothing to pass that exam....
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
December 8, 2011 at 12:02 pm
Brandie Tarvin (12/8/2011)
jcrawf02 (12/8/2011)
SQLRNNR (12/8/2011)
ChrisM@Work (12/8/2011)
SQLRNNR (12/7/2011)
Took the plunge on 70-451Nice one, Jason!
Thanks
Was the braindump useful?:-D
Evil, evil, evil...
Seriously, though, with all the grease in Jason's brain from all those Cheezburgerz,...
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
December 8, 2011 at 11:59 am
Viewing 15 posts - 7,576 through 7,590 (of 19,560 total)