Viewing 15 posts - 5,086 through 5,100 (of 49,571 total)
alessandro.feltrin (8/7/2015)
GODBCC SHRINKFILE (N'ARSystem_log' , 0, TRUNCATEONLY)
GO
Does this sounds better than before?
No. Your previous script was correct with the amendments I made. Replace the first parameter with 2 for...
August 7, 2015 at 11:22 am
Grant Fritchey (8/7/2015)
August 7, 2015 at 6:43 am
You don't need to switch it to simple, and the two options (reorganise or release unused space) are only for shrinking data files.
The command you have there is almost right....
August 7, 2015 at 6:38 am
All GO does is tell SSMS where to break the batches of commands that it sends to SQL Server. Nothing else.
Think of it the same as using two windows for...
August 6, 2015 at 1:22 pm
GO is not a T-SQL keyword. It's an SSMS batch breaker. It delimits the batches sent to SQL Server. Since the CREATE procedure has to be in a batch by...
August 6, 2015 at 12:35 pm
Grant, who works for Redgate, recommends distributed replay. 🙂
Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use SQLMonitor...
August 6, 2015 at 6:55 am
JaybeeSQL (8/6/2015)
Does Distributed Replay work similarly?
Yes, you can use multiple controllers (from multiple client machines) to scale the workload up. You can use the Stress option of distributed replay as...
August 6, 2015 at 4:39 am
I generally recommend that system DBs (master and MSDB) never be restored across instances or servers, even if it works, the chance of lingering problems is far too high. Especially...
August 6, 2015 at 4:27 am
GilaMonster (8/6/2015)
Run the following, post the full and complete, unedited output.
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
August 6, 2015 at 4:24 am
It does a consistency check of the database.
August 6, 2015 at 4:11 am
Then you have a serious problem.
Run the following, post the full and complete, unedited output.
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do not do anything else to the database.
You may want to...
August 6, 2015 at 12:50 am
Yes, because that generates just one ALTER.
Easier way, remove the variable and just have the commands printed to screen, then copy, paste into new query window and run all
SELECT 'ALTER...
August 6, 2015 at 12:33 am
Restore from your last good backup (backup before the corruption happened)
August 6, 2015 at 12:29 am
It's not usually a linear progression. I did a scale-up test for a client last year. As load increased, the CPU increased linearly up to about 2.5x base load, at...
August 5, 2015 at 1:37 pm
jasona.work (8/5/2015)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...
Would you accept winter flu in exchange?
August 5, 2015 at 1:06 pm
Viewing 15 posts - 5,086 through 5,100 (of 49,571 total)