Viewing 15 posts - 19,066 through 19,080 (of 19,560 total)
GilaMonster (11/20/2009)
CirquedeSQLeil (11/19/2009)
When filling space in the files, SQL uses a round-robin method - fill one file then move to the next and then the next, before growing any files.
That's...
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 20, 2009 at 10:11 am
Yes.
To get more specific, we would need table structures, execution plans, and indexes.
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 19, 2009 at 11:26 pm
jasona.work (11/19/2009)
Steve Jones - Editor (11/19/2009)
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 19, 2009 at 11:22 pm
Though the maintenance plan and ssis options are perfectly sound, here is a list of some possible scripts.
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 19, 2009 at 11:00 pm
Yes, logic sounds good. I would enable the write cache
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 19, 2009 at 10:42 pm
Yes networking issue. It really seems like it could be routing table or dns related. You will need to check your routers, dns and adsl setup.
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 19, 2009 at 10:38 pm
Not a real fan of the BE SQL agent. Backup Exec is fine for doing the operating system and file systems. I have seen it cause performance woes.
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 19, 2009 at 9:20 pm
SQL may be able to handle that many tables. The problem is that these are tables being generated (if i understand correctly) through one of the Microsoft CRM products...
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 19, 2009 at 7:56 pm
slightly different than the correlated subquery is the option of using a CTE. Use the cte to join back to the original table to get the results you are...
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 19, 2009 at 4:52 pm
The SSIS package is the method I currently use. I use it for more than just getting DB listings. I have expanded it to be able to inventory...
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 19, 2009 at 4:44 pm
Paul White (11/19/2009)
Alvin Ramard (11/19/2009)
Personally, I remember fondly a time when I was only of two minds. So do I and I and I and I and I...
[font="Courier New"]Msg 530,...
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 19, 2009 at 4:34 pm
While these are valid arguments about nit-picking of questions, one vital piece of information was overlooked. This question was only worth 1 point.
Bitbucket, your question was worth more points....
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 19, 2009 at 4:28 pm
GSquared (11/19/2009)
Paul White (11/19/2009)
GSquared (11/19/2009)
Paul White (11/19/2009)
I'm in two minds about this:http://www.sqlservercentral.com/Forums/Topic821057-145-1.aspx#bm821538
Is it spam? Should I care? Thoughts?
It's spam. You should care.
You're probably right - it's just...
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 19, 2009 at 11:10 am
Paul White (11/19/2009)
Jason, three words of advice, bro:SEEK HELP NOW
:laugh:
Says he who is in two minds :hehe:.
I am only Committed right now, not quite to the Crazy level:-D
Tiz the season...
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 19, 2009 at 11:05 am
heffalumps
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 19, 2009 at 10:57 am
Viewing 15 posts - 19,066 through 19,080 (of 19,560 total)