Viewing 15 posts - 16 through 30 (of 178 total)
One solution is (not pretty and certainly doesn't adhere to best practices!!!) to shrink the logs of other databases (if there actually are any others!!!) on the primary server to...
January 5, 2012 at 5:08 am
are you getting any Resource Semaphore wait types during this period? Could be similar to a problem I had a while ago - Blog Post Here[/url]
Do you know what processes...
January 5, 2012 at 4:59 am
January 5, 2012 at 4:57 am
are you looking for pointers to tutorials etc or actual onsite training?
They don't some much better than : http://www.sqlskills.com/ImmersionEvents.asp
In my opinion, Tuning isn't something you learn overnight.......
January 5, 2012 at 4:53 am
As GSquared has stated, you'll have to tell (or automate via cookies etc) the application to point at the new (Mirror) server via connection strings or similar.
Depending on how the...
January 5, 2012 at 4:51 am
try this link. It may be what you're after......
Or, read the directory of files into a temp table, loop through that deleting the files (using xp_cmdshell) where [text] not like...
January 5, 2012 at 4:45 am
I think we need to have a bit more information in order to form an opinion. Partitioning can indeed improve the performance of a system but so can many other...
January 5, 2012 at 4:41 am
kumar.sachu08 (1/4/2012)
Hi all,When i am going to insert single row in table then it's taking lot of time approx 7 minutes.
Has this always been the case or has it...
January 5, 2012 at 2:51 am
@perry - all i can say is that i've tested both my script (120chars DBName) and also with Calvo's script on both 2005 and sql 2012 RC0 (with...
January 4, 2012 at 9:37 am
Interesting one that, i've just done a test on SQL 2005 and 2012 for a DB with a name of 120chars in length and ran checkdb with nothing other than...
January 4, 2012 at 5:20 am
Barkingdog (12/4/2011)
1. I can't figure our for the life of me where the actual hourly snapshot job is stored in SnapManager. I want to "edit" that existing backup...
December 5, 2011 at 9:40 am
GilaMonster (12/5/2011)
December 5, 2011 at 4:18 am
Single dedicated instance for sharepoint databases only (config and content). Web servers are hosted elsewhere.
Min memory = 22528MB and max = 26624MB.
I'd thought about windows/other apps taking it back but...
December 5, 2011 at 3:23 am
GilaMonster (11/23/2011)
Let me guess, tiny table, index about 5 pages in size?
I'm +1 for this!
November 25, 2011 at 1:17 am
Perhaps i'm being a bit daft here but seeing as we don't fully know the environment or the SQL going through it, wouldn't it be better for you to set...
November 7, 2011 at 2:47 am
Viewing 15 posts - 16 through 30 (of 178 total)