Viewing 15 posts - 16 through 30 (of 120 total)
I have fixed about 10-15 users with this resolution as it's a pain to correct this issue. Check all of the config files (32 and 64 bit) and be...
September 20, 2016 at 12:22 pm
There is a laundry list of things to do on a SQL migration:
Transfer Logins
Transfer SQL Agent Jobs
Re-create any Linked Servers
Re-create Replication
Restore DB's
Run DBCC CHECKDB
Update Stats
etc...
We like to re-ip/re-name the old...
September 20, 2016 at 7:29 am
Run DBCC on ALL of your DB's as that is the only way to tell if a DB has corruption.
September 19, 2016 at 10:52 am
Yep that it!
Resizing the window still will not work if the DB list is large. I just use a different version of SSMS (2012 or 2014 SSMS)...
September 14, 2016 at 12:38 pm
It is normal to restore Prod DB's to a test/dev server for TESTING and development work. There are no issues with this as long as the DEV server is...
June 28, 2016 at 1:59 pm
SQL 2016 Developer Edition is now FREE when you sign up for "Visual Studio Dev Essential Users":
June 28, 2016 at 1:50 pm
The MS resolution to this issue in case anyone else has this issue is as follows:
Resolution: We were able to resolve this for you by completing these steps:
• ...
June 28, 2016 at 1:00 pm
Looks like .net caused it:
(01) 2016-06-14 10:14:24 Slp: Running Action: InitializeMsiAction
(01) 2016-06-14 10:14:24 Slp: Attempting to pause the 32 bit ngen queue for x64
(01) 2016-06-14 10:14:24 Slp: Sco: Attempting to...
June 14, 2016 at 9:30 am
That depends upon if you select "Take this service or application off-line" or "move this service or application to another node". Move this to another node is a failover...
May 25, 2016 at 9:07 am
Also, I question the need for a Full backup nightly (maybe the business has a good reason); however, a weekly Full, a nightly Diff and an hourly (or every X...
May 19, 2016 at 2:00 pm
Another method
In SSMS:
Expand Databases
R-click the DB
Click Reports
Click Disk Usage
At the bottom of the Disk Usage Report click the + by "Disk Space Used by Data Files".
February 25, 2016 at 1:30 pm
Correct early 80's and I have about 9-10 more years to go.
My first experience with SQL/Server I started out on SQL 4.2 (1993 or 1994) with one Help...
January 28, 2016 at 7:35 am
I'm not retired (yet); but, I was a master at loading DOS device drivers (I started on DOS v3) in high memory (CD Device drivers etc...) to free up conventional...
January 27, 2016 at 2:42 pm
Nevermind - operator error - it helps to have the correct IP in the sp_delete_log_shipping_primary_server.
January 21, 2016 at 12:14 pm
We reserve or "lock" the memory for our SQL/Server VMs for performance reasons. If DBServerA VM has 32 GB then we lock all 32 GB so the memory is...
January 12, 2016 at 8:05 am
Viewing 15 posts - 16 through 30 (of 120 total)