Viewing 15 posts - 796 through 810 (of 1,524 total)
It does not report errors. DBCC CHECK DB is clean, DBCC CHECKDB with data_purity is clean
All three things do not report any issues. I also...
May 18, 2012 at 9:10 am
I guess what I mean is a new vunerability that can be exploited in SQL Server... remember Slammer in 2003... Microsoft had to write a fix to the binaries...
May 16, 2012 at 7:27 am
Not enough really. I don't think a CIO/CEO would say that is acceptable if someone wreaked havoc on that SQL Server install or stole data from it and I...
May 16, 2012 at 6:55 am
The big problem with running it beyond 2014 is that if a virus comes out that effects SQL2000 Microsoft will no longer create a fix for it. THAT is...
May 16, 2012 at 5:54 am
Do you control the backups/restores? Is SQL Server patched automatically if a service pack or security patch comes out? If so, and it causes issues with your application...
May 9, 2012 at 5:57 am
For you baseball stat people:
Reds Vs Cubs game yesterday:
Homer Bailey is going to the Hall of Fame.
Starting pitchers Homer Bailey and Ryan Dempster faced each other on their birthdays. Bailey...
May 4, 2012 at 9:30 am
I agree. All you need to do is Rebuild the indexes. Don't shrink the .mdf unless you really need to gain the space back. REMEMBER, when you...
May 2, 2012 at 8:38 am
Also, check to see what the growth rate of the TEMPDB .mdf and .ldf files are and if it is set to extend at all. Also, file growth, is it...
May 2, 2012 at 8:35 am
You will still have an outage because users will need to connect to the new db server name.
May 1, 2012 at 1:24 pm
If you start a Profiler session just for the specific database that those queries are running against it will tell you what userid and where the queries are being run...
May 1, 2012 at 12:41 pm
No matter how you attempt this there will be some time for an outage. It all depends on how large the database is. One other thing you need...
May 1, 2012 at 11:39 am
Have you setup profiler to capture these statements? If not, try that. It will tell you what userid and from what server/workstation they are coming from and that...
May 1, 2012 at 11:37 am
Typically you should backup all databases before you apply any SP or CU. I also stop the SQL Server services and backup the master, msdb, model .mdf and...
May 1, 2012 at 11:33 am
Our two store critical systems have been on SQL2000 because the cost justification just was not there. Our one system that is in rollout of a new application release...
April 30, 2012 at 8:01 am
We are in the middle of our largest SQL Server in our stores upgrade right now. The DB is moving from a Win2003 Active/Passive cluster running on SQL2000. ...
April 30, 2012 at 5:59 am
Viewing 15 posts - 796 through 810 (of 1,524 total)