Viewing 15 posts - 12,481 through 12,495 (of 19,560 total)
Try the script at:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
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
September 12, 2010 at 7:50 am
Lennie (9/12/2010)
A helper is supposed to assist by ...
Odd to instruct others on how you must respond in a forum, when you shout in the forums as you did with...
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
September 12, 2010 at 7:49 am
Very nicely explained by Gail and Paul.
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
September 12, 2010 at 7:45 am
If you're interested, I also have a few queries up on my site that can help with finding the the size and free space.
http://jasonbrimhall.info/2010/05/05/sql-2005-tablespace/
As Duncan said, you probably have some...
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
September 12, 2010 at 2:24 am
I think a good place to start on this is to check books online or google Recovery Models..
In simple recovery mode, the log will checkpoint and you will lose 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
September 12, 2010 at 12:21 am
I agree with the others on this.
One thing to note is that 15 applications / or 15 databases is not a burden for SQL server in many cases. There...
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
September 12, 2010 at 12:19 am
Do you have any defaults set on the table that calculate from other columns? Do you have any triggers on this table?
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
September 11, 2010 at 8:53 pm
UMG Developer (9/11/2010)
GilaMonster (9/11/2010)
Yuk. And that's a feature?
I can see how it could be useful for storing flag like things. Now that I think about it, it is just storing...
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
September 11, 2010 at 8:32 pm
I think something like that could be quite useful. TOAD for SQL server does a similar thing - if you let it. It can take a query 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
September 11, 2010 at 8:05 pm
It's tough when it is for charity. Priorities usually are for the job that brings in the bacon for the family. After that - it is somewhat a...
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
September 11, 2010 at 8:01 pm
Here's a shortcut to learn how to script those backups.
Through the gui, make the selections you need. Reassign the name, file names, and file locations as necessary. 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
September 11, 2010 at 7:57 pm
Time to start prepping a TSQLTuesday post.
if anybody is interested the hashtag is #tsql2sday on twitter.
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
September 11, 2010 at 1:26 pm
Tom.Thomson (9/11/2010)
CirquedeSQLeil (9/11/2010)
Anybody else want to try this one?Would a reference to https://secure.wikimedia.org/wikipedia/en/wiki/Microsoft_SQL_Server#Architecture be cruel?
No.
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
September 11, 2010 at 1:24 pm
GilaMonster (9/11/2010)
Alvin Ramard (9/11/2010)
CirquedeSQLeil (9/11/2010)
Anybody else want to try this one?Why? The ball is in the OP's court. Nobody should make a move until he does.
Looks like he...
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
September 11, 2010 at 1:23 pm
I think Gail's response pretty much covers the gambit multiple times over.
Read through the references she provided and then post specific questions.
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
September 11, 2010 at 12:38 pm
Viewing 15 posts - 12,481 through 12,495 (of 19,560 total)