Viewing 15 posts - 13,141 through 13,155 (of 19,560 total)
balaji.ganga (7/27/2010)
This is for your optional,you just restart the services. New tempdb will created automatically.
Thanks
Balaji.G
True. Restarting the services will recreate 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
July 27, 2010 at 8:47 am
I like the point that we could start with something canned and develop that into something more specific to our needs. Let the users do a bit of 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
July 26, 2010 at 8:45 pm
What kinds of indexes are on this table?
How many indexes are you rebuilding for 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
July 26, 2010 at 8:26 pm
Steve Jones - Editor (7/26/2010)
As I've learned to run and swim (yes, you learn how), I find that I get some great thinking time there. Driving as well.
I can agree...
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
July 26, 2010 at 5:09 pm
SA can be the owner of the jobs. The jobs will execute as the Agent Service Account - unless otherwise specified (proxy). I typically set my agent service...
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
July 26, 2010 at 4:30 pm
I have seen Sorcerers Apprentice as well. I enjoyed it. Have not seen either of the other two movies.
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
July 26, 2010 at 4:28 pm
Lynn Pettis (7/26/2010)
CirquedeSQLeil (7/26/2010)
Not too old. Maybe the naysayers should be reminded that they are too immature to be a dba. 😀
I'll second this sentiment. Why is development...
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
July 26, 2010 at 4:21 pm
Lynn Pettis (7/26/2010)
CirquedeSQLeil (7/26/2010)
...So you are trying to work less so you can work more? :-D;-)
I have found that I truely enjoy working with SQL Server and I want 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
July 26, 2010 at 4:13 pm
Not too old. Maybe the naysayers should be reminded that they are too immature to be a dba. 😀
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
July 26, 2010 at 4:09 pm
Lynn Pettis (7/26/2010)
CirquedeSQLeil (7/26/2010)
GilaMonster (7/26/2010)
The Dixie Flatline (7/26/2010)
GilaMonster (7/26/2010)
Jack Corbett (7/26/2010)
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
July 26, 2010 at 3:54 pm
Should have added, I am currently running numerous DTS packages on SQL 2008 with Win 2008 R2 64 bit.
I have written a little bit about it in my blog.
http://jasonbrimhall.info/2010/07/07/sql-2008-dts/
and
http://jasonbrimhall.info/2010/07/23/a-little-dance-with-ssis-and-informix/
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
July 26, 2010 at 3:53 pm
Yes they do.
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
July 26, 2010 at 3:50 pm
GilaMonster (7/26/2010)
The Dixie Flatline (7/26/2010)
GilaMonster (7/26/2010)
Jack Corbett (7/26/2010)
Wow, Honeywell is hiring a database guy. Based on the databases I've seen behind Honeywell products you are the first.
That's not something...
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
July 26, 2010 at 3:21 pm
Alvin Ramard (7/26/2010)
... can't help but wonder if all the time Lynn spent in a tent in the desert helped get the new position ... hmmmmm
That was all really top...
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
July 26, 2010 at 1:52 pm
Yes - shrink as small as you can. Then grow it out to 15GB (following the example) but grow it in chunks of about 4gb-5gb.
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
July 26, 2010 at 1:45 pm
Viewing 15 posts - 13,141 through 13,155 (of 19,560 total)