Viewing 15 posts - 331 through 345 (of 612 total)
I would recommend creating a Central Management Server and registering each of the databases that will have CDC enabled. You can then run a single statement against all of...
October 1, 2014 at 6:49 am
Perry Whittle (9/26/2014)
kevaburg (9/26/2014)
What happens if I perform a backup over the network and I have an outage?
It will fail and you'll need to restart the backup from the...
September 26, 2014 at 8:45 am
Hi Folks,
I don't know if I should start another thread for this question but I think here is appropriate....
What happens if I perform a backup over the network and I...
September 26, 2014 at 5:55 am
Hi Folks,
I don't know if I should start another thread for this question but I think here is appropriate....
What happens if I perform a backup over the network and I...
September 26, 2014 at 5:40 am
Thank you very much for a really helpful script!
September 11, 2014 at 5:25 am
You could give the user the ALTER TRACE permission and let them run the Profiler when they need it.
Just be sure to tell them how NOT to use it first...
September 8, 2014 at 6:46 am
The only way to get a historical record of queries run is to run a trace at the time that you want to observe. Otherwise you have dipped-out.....
September 8, 2014 at 6:43 am
The user executing the query must be mapped to database B in order to access the view inthe first place. A securable on the view should then be configured...
September 8, 2014 at 1:30 am
kevaburg (8/7/2014)
I am trying to create a custom filename that has the current date and time appended to the original filename. What I have created up until now...
August 8, 2014 at 12:47 am
Cadavre (8/7/2014)
Or append 114 to your current query: -
SELECT 'plan_werte_' + CAST(REPLACE(CONVERT(VARCHAR(26), GETDATE(), 112) + CONVERT(CHAR(5), GETDATE(), 114), ':', '') AS VARCHAR(50)) + '.csv';
Thanks for the answer but the...
August 8, 2014 at 12:32 am
Many thanks to everyone for your input!
Because this was quite an important job (and also because I wanted to go on holiday!) I decided to export the data for each...
August 1, 2014 at 12:19 am
StephenNL (3/12/2014)
In the picture above, I choose transaction log (Transaktionsprotoll in German) and select the database.But I guess, with simple recovery no log file is needed.
No that isnt true. ...
March 18, 2014 at 3:18 am
praneethydba (3/18/2014)
HI,Its going high from 52% to 65,70,72 & today 80%...
tomorrow it may reach 90 & finally 100%...
You are truly not grasping this. Just because 100% of the memory...
March 18, 2014 at 3:11 am
Have you considered the advice of most people here in that you don't need to worry?!
March 18, 2014 at 2:56 am
To be honest I would question whether something really is wrong. As has been mentioned in this post, SQL Server will use whatever memory is allocated to it which...
March 7, 2014 at 6:20 am
Viewing 15 posts - 331 through 345 (of 612 total)