Viewing 15 posts - 30,526 through 30,540 (of 39,754 total)
what are you trying to do? This is such an open ended question, it's hard to answer.
SQL Server 2005 has data encryption features, but you want to be careful about...
December 2, 2007 at 12:57 pm
If you have moved all services to their own network accounts, then this should not be a problem. Each service runs under the context of the service account, or under...
December 2, 2007 at 12:52 pm
No, you have two constraints with different names,
December 2, 2007 at 12:49 pm
Each instance requires its own IP. You can set those in the Configuration Manager.
However, you should be very careful about exposing 1433 to your public side. A report last week...
December 2, 2007 at 12:48 pm
Check the links and is there a point to what you are asking? Meaning why do you need to know?
If it's curiosity, there's a lot out there to read about....
December 2, 2007 at 12:45 pm
If you use one of the third party backups, LiteSpeed or Red Gate Backup, they might do object recovery for you (depends on version). SQLCompare from RedGate, does comparisons from...
December 2, 2007 at 12:44 pm
What I'd first recommend is that you get a list of queries that are run often and then search through those to see if you can improve their performance. You...
December 2, 2007 at 12:42 pm
Keep the log and data together if you don't have another volume. You want them protected.
The error has nothing to do with log and data files. It sounds like the...
December 2, 2007 at 12:39 pm
I don't and a few searches haven't turned up anything. Have you tried the backupdevicecollection.
Or maybe one of the restore classes? That might grab the data from the backuphistory tables.
December 2, 2007 at 12:37 pm
I think that's the best approach and thanks for the update.
December 2, 2007 at 12:32 pm
Actually I tend to postfix so I can group similar functions together. I want the
uspSalesGetforQuarter
right next to the
uspSalesGetAllforSalesman
As opposed to
uspGetAllSalesforSalesman
uspGetAllProductsforCustomer
...
uspGetSalesforQuarter
I've found that it's pretty easy to identify the major...
December 2, 2007 at 9:31 am
OK, you have 3 large questions and I'm not sure about #2. Need a BI/SSAS person to answer or give hints. I will say that you need to determine if...
December 1, 2007 at 3:58 pm
SQL Server 2008 will have things built in to help ensure that the files are synchronizes with the data, they can be backed up, but also queried with T-SQL.
There is...
December 1, 2007 at 3:53 pm
In a cluster, each individual instance needs to be reset if those host names are changing. They will bind to the IP of that server.
If the IP of the virtual...
December 1, 2007 at 2:28 pm
Yes, as far as checking to see if indexes are being used, you can use the DMVs so see what's being used.
This blog post can help: http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx
December 1, 2007 at 2:27 pm
Viewing 15 posts - 30,526 through 30,540 (of 39,754 total)