Viewing 15 posts - 19,141 through 19,155 (of 59,072 total)
GilaMonster (11/4/2015)
Jeff Moden (11/4/2015)
ramyours2003 (11/4/2015)
is running a profiler will make the tempdb grow?Depending on where you run it from and how you run it
Profiler can fill up the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 8:11 pm
sqld-_-ba (11/6/2015)
- the name should easily identify actual server...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:58 pm
p.s. Allocating another 50-100GB to the app is going to be a whole lot cheaper than you having to mess around all the time whenever you defragment the tables.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:52 pm
have2much (11/9/2015)
- switch recovery model of the database to simple before starting rebuild and switch to full once done ?
- Partitioning may also help where you do have...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:47 pm
Welsh Corgi (11/9/2015)
Jeff Moden (11/9/2015)
Welsh Corgi (11/9/2015)
I have been asked to Partition the tables.
Would I be better off to hold off on...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:34 pm
ricardo_chicas (11/9/2015)
ThanksI will do something similar, add a new file group and move those tables over there
What is the table used for? For example, is it an audit or...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:17 pm
Gordon Feeney (11/17/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:11 pm
Disclaimer: I am NOT an SSIS user. I do this type of stuff using T-SQL and I'm not even sure that I know how to even spell "SSIS"....
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 7:02 pm
yb751 (11/11/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 6:25 pm
MadAdmin (11/10/2015)
Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014
Yes.
Because the DB was then able to successfully...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 5:32 pm
If it's an AD account, you shouldn't have to do anything with "SQL Credentials" that already exist. If by "SQL Credentials", you mean an SQL Login rather than a...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 5:29 pm
S_Kumar_S (11/17/2015)
I have a tempdb with 130 GB mdf and 6 GB ldf file size. Now because of PAGEIOLATCH_XX wait types, I have to a make the number of...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 5:23 pm
keymoo (11/17/2015)
So SERVER1\INSTANCE_A has...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 5:19 pm
Hugo Kornelis (11/17/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 4:39 pm
Lynn Pettis (11/17/2015)
OMG
Unfortunately, WTC (Way Too Common). Gail has got to be getting tired of suppressing a literal "Dear Stupid" response.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 17, 2015 at 4:34 pm
Viewing 15 posts - 19,141 through 19,155 (of 59,072 total)