SQLRNNR

Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 19,560 total)

RE: SQL Server 2012 CTP

They moved things around a bit.
Try this link
https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/
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

November 8, 2011 at 4:54 pm

#1404914
RE: User connecting to reportserver database from reportserver

What are you specifying in your datasources?
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

November 8, 2011 at 4:52 pm

#1404911
RE: "error generating the XML document" during 2008 R2 install

Check this to find the cause and possible fix for the issue.
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/10d4ab5c-55be-4dd1-8ca7-13a1703bd9f0/
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

November 8, 2011 at 3:58 pm

#1404899
RE: Starting with "WITH"

Things are real good right now. Fresh snow, cold weather and keeping busy with work and kids.
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

November 8, 2011 at 3:55 pm

#1404898
RE: Starting with "WITH"

The Dixie Flatline (11/8/2011)
Has it really been a year? Oh wow....
At a minimum.
How are things going anyway?
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

November 8, 2011 at 3:50 pm

#1404895
RE: Dynamic Connection String

See if this article helps.
http://msdn.microsoft.com/en-us/library/ms141682.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

November 8, 2011 at 3:49 pm

#1404894
RE: Exam 70-433 help

I didn't use a book but used the list of objectives provided by Microsoft. My opinion, that material was enough to prep.
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

November 8, 2011 at 3:44 pm

#1404891
RE: Dynamic Connection String

Use a variable for the ConnString that you use to overwrite the Expression.
Then set the variable to the appropriate environment at design time.
When you setup the job, you can specify...
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

November 8, 2011 at 3:37 pm

#1404889
RE: INSERT into sys.objects on 2008

Cannot be stressed enough the cautions Gail threw your way on this. Do not attempt to edit sys.objects
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

November 8, 2011 at 3:32 pm

#1404888
RE: Are the posted questions getting worse?

GilaMonster (11/8/2011)
I give it about a month and a half to two months before I pass Steve for top place overall.
Taking a break? Just curious why waiting so long...
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

November 8, 2011 at 2:51 pm

#1404869
RE: Starting with "WITH"

ChrisM@home (11/8/2011)
The Dixie Flatline (11/7/2011)
I agree with Chris.
Because I inadvertantly started (this very entertaining and informative discussion) by making a "suckish" comment, I feel compelled to admit that 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

November 8, 2011 at 2:44 pm

#1404863
RE: Are the posted questions getting worse?

Ninja's_RGR'us (11/8/2011)
BOOya
Impressive
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

November 8, 2011 at 2:41 pm

#1404859
RE: Trancender too simple?

Those exams may be nice simulation practice, but they don't really teach the topics.
Nothing beats breaking down the exam criteria, studying the points, and practicing those areas.
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

November 8, 2011 at 11:42 am

#1404747
RE: Restore Script..?

You mean restore prod db to a different server such as QA or UAT?
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

November 8, 2011 at 10:45 am

#1404719
RE: Are the posted questions getting worse?

Ninja's_RGR'us (11/8/2011)
WayneS (11/8/2011)
GilaMonster (11/8/2011)
Clustered indexes enforce physical sort order of rows
Nonclustered indexes can't be built on a heap
Nonclustered indexes on a heap can't be rebuilt
I've never heard that third one.
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

November 8, 2011 at 8:58 am

#1404633

Viewing 15 posts - 7,951 through 7,965 (of 19,560 total)