Viewing 15 posts - 9,331 through 9,345 (of 22,214 total)
There are built in utilities that let you monitor drive space on the system. Here's an example[/url] on how to use it.
December 3, 2013 at 3:21 am
You're best bet would be to contact Microsoft directly to find out what licenses the company you purchased has through them. There's nothing stored within a SQL Server installation that...
December 3, 2013 at 3:16 am
Ed Wagner (12/2/2013)
WayneS (12/2/2013)
Sounds about as good as being in anEnglishBritish port, and your name is Randy (not an abbreviation...).
I'm glad you did the strikeout with English and...
December 2, 2013 at 12:29 pm
When you run a full backup, it also backs up the transaction log. If your transaction log has 30gb of transactions that have not been backed up (guessing based on...
December 2, 2013 at 10:48 am
You can just script out the creation of the counters and then run the script on the other server. You can save the counters you have as a template (I'm...
December 2, 2013 at 10:45 am
You're basically running into limitations of the generic nature of Maintenance Plans. If they work for you, great. If they don't, the only real recourse you have is to start...
December 2, 2013 at 10:41 am
Yeah, the text is part of the issue and forced parameterization could help some. But it's use is pretty limited. Again, I'd turn it on to see if it can...
December 2, 2013 at 4:35 am
Plus the fact that no unique constraints radically changes the optimizers choices for retrieving data. I'll bet you see a LOT more scans than you should since the optimizer has...
December 2, 2013 at 4:10 am
Three suggestions.
Most of what you're going for from that basic list are either system variables (@@servername, @@version, etc.) or can be accessed from the sp_configure query. So yeah, getting that...
December 2, 2013 at 4:06 am
This introduces the concept of the a partial backup. As everyone has already stated, you can only do this if you design the database and it's structure to support the...
December 2, 2013 at 3:59 am
I'm going to follow on what the others have said. You first have to demonstrate that you have the core knowledge of SQL Server before I start asking you other...
December 2, 2013 at 3:51 am
Forced Parameterization has a very limited set of cases where it will be applied. It's only slightly more likely to be used by the optimizer than simple parameterization. Check the...
December 2, 2013 at 3:47 am
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him...
November 22, 2013 at 7:54 am
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
No one is aware...
November 18, 2013 at 11:27 am
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...
No one is aware of anything like that....
November 18, 2013 at 9:30 am
Viewing 15 posts - 9,331 through 9,345 (of 22,214 total)