Viewing 15 posts - 226 through 240 (of 1,583 total)
In your admin for the dell RAID controllers, have you checked to see if the batteries are showing warnings? I've seen issues in the past with Dell servers getting slow...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 8:49 am
If you don't mind using SSIS - You can also use the transfer jobs, transfer logins, transfer SQL objects, and transfer master stored procedures tasks in SSIS to keep the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 8:39 am
Also look in the actual report server logs (should be located in ..\MSSQLSERVER\Reporting Services\LogFiles) and post if anything is amiss there
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 8:36 am
Thanks Grant, I am already using a combination of trace and IO, was just wondering if there was something better (i.e. extended events) - thanks for that
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 5:47 am
Grant, what would be the best way to achieve that? SET STATISTICS TIME ON?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 9:20 pm
I used to do it using a sp as well, then discovered it was a heck of a lot easier with the trace, then created a process to import a...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 9:15 pm
If you publication(s) were set up to replicate schema changes then it will replicate. ALTER TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER will be replicated. ALTER TABLE D-ROP COLUMN is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 9:13 pm
You could also create a very "light" server side trace using the default TSQL template in Profiler, remove all the columns you don't need, and a filter for the exact...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 9:05 pm
Rather than adding the column to the '"leading edge" you might want to consider adding it to the end of the index...this may help with the overall selectivity of the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 9:03 pm
You should do it for all disks from the initial set up, and most importantly (not sure this still applies for server versions beyond 2008 so you may want to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 8:55 pm
If you are simply physically moving the database files from SAN - SAN, it's just a matter or changing the locations via TSQL, shutting down the replication agents as you've...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 8:50 pm
I manage 21 servers with about 12 DB's per server, total size is about 11TB (with 2 servers accounting for 9TB of that total amount)
Good Lord Jason :w00t: HOW...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 8:40 pm
I believe this is an issue with your account versus the "proxy" account. This is a very common issue....
Verify that the proxy account can access the FTP site using...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 3, 2014 at 7:51 am
This may work better as you don't need to run it for any given table SELECT OBJECT_NAME(c.object_id) ,
c.name ,
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 2, 2014 at 10:26 pm
Please refer to this excellent article regarding Transaction Logs: http://www.sqlservercentral.com/articles/Administration/64582/
Bulk-logged is very similar to full recovery, except that in bulk-logged, bulk operations are minimally logged. When operations are minimally...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 1, 2014 at 9:58 am
Viewing 15 posts - 226 through 240 (of 1,583 total)