Viewing 15 posts - 7,141 through 7,155 (of 19,560 total)
GilaMonster (1/14/2012)
Jeff Moden (1/13/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
January 14, 2012 at 9:20 am
Congrats Lowell.
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 13, 2012 at 11:42 pm
Jeff Moden (1/13/2012)
Sean Lange (1/13/2012)
Jeff Moden (1/13/2012)
Sean Lange (1/13/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
January 13, 2012 at 10:50 pm
Jeff Moden (1/13/2012)
I've always felt that using Transcender and other "practice tests" just wasn't the right thing to do. It seems to me that using such...
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 13, 2012 at 10:46 pm
I'm with Sean - use a Date datatype.
Sit down and chat with the business about the cases why any part of the date of birth would be unknown.
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 13, 2012 at 10:37 pm
LutzM (1/13/2012)
The "missing" reputation system might be exactly the reason for this site to be what it is to me: the best and most professional SQL Server site.
I prefer 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
January 13, 2012 at 6:25 pm
based on what you are saying, it seems this is a SQL2005 or newer Database server.
The sys.servers view is visible from within the resource database. You would have to...
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 13, 2012 at 12:42 pm
countdown
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 13, 2012 at 9:50 am
Good to hear...
So did you add the exec, or did you decide to use the method outlined by Gail?
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 13, 2012 at 9:46 am
It should work if you add exec in front of the sp_dboption.
At least it did in my test.
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 13, 2012 at 9:32 am
Cliff Jones (1/13/2012)
The word 'Always' should have made me think twice, but alas I only thought once.
That is the key word that made me rethink.
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 13, 2012 at 9:13 am
Is the database being logshipped or replicated by any chance?
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 13, 2012 at 9:11 am
This should be a "basics" question but is not necessarily easy.
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 12, 2012 at 11:07 pm
alyssajames37 (1/12/2012)
i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation
So you admit to cheating and violating the NDA?
Braindumps are not an appropriate...
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 12, 2012 at 11:03 pm
have you tried to connect to the report server by launching IE by right clicking and selecting "run as administrator"?
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 12, 2012 at 12:10 pm
Viewing 15 posts - 7,141 through 7,155 (of 19,560 total)