Viewing 15 posts - 301 through 315 (of 409 total)
Before moving the inactive rows to another table be sure to take into account the potential effects on reporting, data warehouse, etc. If you're "archiving" your inactive customers to another...
July 25, 2007 at 11:20 am
Just to clarify:
(1) SQL Server logins (e.g. SA) do not have a corresponding windows login that can be retrieved, SQL Server logins are maintained entirely within SQL Server and have no...
July 25, 2007 at 1:22 am
One option would be to add the number of rows to be displayed in the report as a parameter and then use "TOP" to return only the number of rows...
July 25, 2007 at 12:42 am
Just out of curiosity what percent of your 2 million rows are active? Depending on the percentage of the rows that are active/inactive the position of the bit field in...
July 25, 2007 at 12:30 am
Rather than fight with your version of SSMS why not just go download one of the free tools available on the web to do just what you need? Search for...
July 25, 2007 at 12:12 am
If it's accessible from the web you'll most definitely want per processor. The scenario you've described is called "multiplexing" (see http://www.microsoft.com/sql/howtobuy/multiplexing.mspx) and pretty much every database vendor disallows this...
July 24, 2007 at 11:54 pm
Given appropriate indexes, current statistics, etc. the optimizer will come up with the same or better query plan than a human most (say 99%) of the time.
That said, there is the...
July 24, 2007 at 11:47 pm
Maybe too much to ask for an easy fix but have you checked to make sure your database has enough room to accept all these inserts?
Make sure the database has...
July 24, 2007 at 11:27 pm
Window, gotta be a window - well maybe not.
Pro's - I can see what a beautiful day it is outside.
Con's - I can see what a beautiful day it is...
July 24, 2007 at 11:22 pm
Al -
Have you taken a look at either SQL Compare from Red Gate or ApexSQL's tool? I've used the command line version of SQL Compare in conjunction with NANT to...
July 24, 2007 at 11:15 pm
Robert -
Is replacement of your RAID 5 with new drives your only option? How about adding additional drives/channels either internal or external to the server?
Between the cost of "big"...
July 24, 2007 at 10:31 pm
I'll vote with Ralph on this one, what you've got is best described as a operational data store...
Joe
July 24, 2007 at 10:02 pm
Mohammad -
Just a quick comment then a couple of questions.
Comment: Your problem is not necessarily a problem with DTS, your code is utilizing an external resource (the FileSystem object) to...
July 24, 2007 at 9:46 pm
Derek -
The article referenced is a good start, but may or may not fit depending on your situation.
A couple of questions that may help us provide a little more help:
(1) ...
July 24, 2007 at 9:19 pm
I'll echo Brandie here - access to resources outside the local machine requires a domain or other account with access to the target machine whether another windows machine,...
July 17, 2007 at 9:52 am
Viewing 15 posts - 301 through 315 (of 409 total)