Viewing 15 posts - 11,386 through 11,400 (of 39,963 total)
Going to submit to SQLBits. Gonna be a busy summer, it looks like.
March 3, 2014 at 9:13 am
If you're trying to save money on licensing, I don't believe you an upgrade. However you can purchase 2012 Standard and "migrate" to this version.
March 3, 2014 at 9:03 am
GilaMonster (3/3/2014)
Take a read through this, identify why it's growing. Post back if you need further help once you've identified the root causehttp://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Read through Gail's article. We can't see your...
March 3, 2014 at 8:57 am
You could use Powershell here. A job that calls this script and outputs to a filename based on the date.
There's a rename script here: http://ss64.com/ps/syntax-stampme.html
Here's a text file export:...
March 3, 2014 at 8:56 am
One big thing would be to move to a stable x64 platform. That was an add-on in SQL 2000, but in SQL2K8 you can easily use more memory, which should...
March 3, 2014 at 8:54 am
Datagod-309892 (3/3/2014)
March 3, 2014 at 8:50 am
Backup/restore for me as well.
I might script this as a daily process that moves the latest backup from production to test, but doesn't necessarily restore it. This would make it...
March 3, 2014 at 8:48 am
I haven't typically seen connection issues taking many resources in SQL2K5+ instances. In SQL 7, it could be an issue, but usually in the 1000s of connections.
Does the app have...
March 3, 2014 at 8:47 am
MyDoggieJessie (2/28/2014)
Try DBCC CHECKTABLE on the table that has the clustered index. No point in checking the entire DB when it's just the one table reporting the issue?
+1
March 3, 2014 at 8:43 am
Personally, I like the logic clear so if I glance at this in a year, or someone else does, it makes sense. I'd do this:
DECLARE @year INT
, @DateFirstIssued...
February 28, 2014 at 11:40 am
richj-826679 (2/28/2014)
+1 for FoundationThe Dark Tower series by Stephen King was supposedly in the works. Hopefully it would translate better than the mangling of Under the Dome.
Was the series...
February 28, 2014 at 11:17 am
Don't commit, but if you think of ideas, make notes, or post them here. It would be good to have a nice set of 5-10 situations where cursors are replaced.
February 28, 2014 at 11:16 am
Feel free. Shouldn't be too long. Give a procedure and show how it works with a test user or two.
February 28, 2014 at 9:35 am
Can you track when changes are made to tables?
The replication process looks like any user sending a DML change to the server. To trigger on that, you'd need a trigger...
February 28, 2014 at 9:13 am
Potentially you have some sort of open transaction, close mirroring/ replication, that prevents the log from being cleared completely.
In terms of the size, I guess it's possible you need that...
February 28, 2014 at 9:09 am
Viewing 15 posts - 11,386 through 11,400 (of 39,963 total)