Viewing 15 posts - 10,486 through 10,500 (of 22,213 total)
Looking at this, the first thing I'd suggest is you update your statistics. They're pretty badly out of wack. That might be why you're getting such an expensive plan. You're...
September 14, 2012 at 11:53 am
jcrawf02 (9/14/2012)
My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php
Where do I go to volunteer?
September 14, 2012 at 11:20 am
Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also look at sys.dm_exec_query_stats to see...
September 14, 2012 at 9:14 am
Yeah, TDE gets you encrypted backups. Other than that, you need to look at something like Red Gate SQL Backup[/url]. We do encryption and password protection. The tool also provides...
September 14, 2012 at 9:12 am
Yeah, if the question is a follow-up to a discussion in the thread, I tell them to post it to the thread and I answer it there. I won't mess...
September 14, 2012 at 9:08 am
Catcha (9/14/2012)
Yes, with recreating the index I will use the following orderNon-clustered -> primary key -> clustered
So rebuilding of whole table will be performed last.
Thought?
Nope. Backwards. If...
September 14, 2012 at 9:02 am
I can't see the attachments. Based on what's described, I have a guess. That sounds like a messy complex query. I'll bet, if you look at the Reason for Early...
September 14, 2012 at 9:00 am
ksr39 (9/11/2012)
Actually I am taking my backup from cmd window with a script it’s a general script to take a backup, but I am taking the backup file to a...
September 14, 2012 at 8:51 am
OceanDeep (9/13/2012)
September 14, 2012 at 6:02 am
Good suggestion. I haven't started tuning the query yet, but that's absolutely one of the changes I'll make. Thanks.
September 13, 2012 at 6:03 am
Another suggestion. Get a copy of virtualbox. It's free. You can install your OS to a virtual machine and get it set, then make a copy. Try installing SQL Server...
September 6, 2012 at 2:34 pm
Do you mean that you used the uninstall process for software through the Control Panel? If so, you should be ready to go for a clean install. If you did...
September 6, 2012 at 1:44 pm
GilaMonster (9/5/2012)
What you describe (SSMS starting and asking you to connect to a server) is completely correct...
September 6, 2012 at 5:42 am
Brandie Tarvin (9/5/2012)
L' Eomot Inversé (9/5/2012)
Brandie Tarvin (9/5/2012)
Steve Jones - SSC Editor (9/4/2012)
September 5, 2012 at 7:23 am
jrichards54 (9/3/2012)
September 4, 2012 at 2:05 pm
Viewing 15 posts - 10,486 through 10,500 (of 22,213 total)