Viewing 15 posts - 8,026 through 8,040 (of 19,560 total)
Much the same as the others who have posted.
There is no shortage of information or material overload in SQL, databases or even Oracle.
If you have the desire to learn 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
November 3, 2011 at 4:56 pm
Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.
I have seen them perform marvelously as well. For instance we...
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 3, 2011 at 4:53 pm
For a very similar requirement we backed up and restored databases from one server to another on a nightly basis. It was much faster (due to size) to backup...
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 3, 2011 at 4:49 pm
KWymore (11/3/2011)
I like it! Too bad I mostly work from home, the users can't hear me.
That's what conference calls are for:-D:-D
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 3, 2011 at 4:45 pm
It sounds like the metadata just needed updated. By chance were the two columns similar in name? Or did you remove one, then add it back and then...
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 3, 2011 at 4:45 pm
Yes you can.
You would create a data connection to the database inside your script and then insert those records into the table.
Here is an article on creating such a connection.
http://msdn.microsoft.com/en-us/library/ms135939.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 3, 2011 at 4:39 pm
elkucho (11/3/2011)
Works fine now!Thanks a lot for all the answers!
Congrats - that is good.
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 3, 2011 at 4:35 pm
Can you run the query and retrieve the XML - then try clicking the xml link and see if it behaves differently?
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 3, 2011 at 4:34 pm
Daniel Bowlin (11/3/2011)
SQLRNNR (11/3/2011)
crookj (11/3/2011)
WOTD - ComplimentaryBuffet
Smörgåsbord
Boardwalk
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 3, 2011 at 4:32 pm
Evil Kraig F (11/3/2011)
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 3, 2011 at 4:25 pm
Evil Kraig F (11/3/2011)
SQLRNNR (11/3/2011)
GSquared (11/3/2011)
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 3, 2011 at 4:23 pm
GSquared (11/3/2011)
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 3, 2011 at 3:48 pm
GilaMonster (11/3/2011)
Brandie Tarvin (11/3/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
And why...
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 3, 2011 at 11:15 am
crookj (11/3/2011)
WOTD - Complimentary
Buffet
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 3, 2011 at 10:39 am
Revenant (11/3/2011)
SQLRNNR (11/3/2011)
Ray K (11/3/2011)
overwhelmedoverweight
Overfed
underactive
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 3, 2011 at 10:17 am
Viewing 15 posts - 8,026 through 8,040 (of 19,560 total)