Viewing 15 posts - 331 through 345 (of 495 total)
Uh, why would you let anyone but an experienced DBA be in charge of changing an index from clustered to non-clustered? At that point your problem would be that...
August 16, 2010 at 7:22 am
Make certain that the AD account you log in with is in the Administrators group on the local server.
August 13, 2010 at 1:00 pm
That's probably OK for now, it wouldn't cause your problem. It would only be a problem if SQL Server had to do anything over the network like backup to...
August 13, 2010 at 12:15 pm
Can you confirm the accounts that SQL Server itself is running on? That would be in the Services control panel on the server itself. Could be that the...
August 13, 2010 at 11:53 am
If 20 million rows a month are getting added on average, I think you can assume that there are no empty partitions. Come on.
August 13, 2010 at 7:39 am
Come on -- historical questions can be fun, even if they don't mean anything about today's environment!
And good lord, I got it right because I did have to deal with...
August 13, 2010 at 7:34 am
Christian Buettner-167247 (8/13/2010)
I was not sure about the history data. Although the QOTD specified that an average of 20000 rows per month were imported, it did not tell you that...
August 13, 2010 at 7:24 am
As far as my helping is concerned, you're on your own in Access. I make it a point to stay as far away as I can. I am...
August 12, 2010 at 2:46 pm
Do you mean sp_updatestats or DBCC UPDATEUSAGE(0)?
August 12, 2010 at 12:01 pm
ashish.kuriyal (8/12/2010)
open cmd and runsqlcmd -L
if you want output of this in text file, lets say in c drive then :-
sqlcmd -L >c:\serverlist.txt
This only works on SQL Servers that the...
August 12, 2010 at 11:57 am
Re-reading that, I think I should be more specific -- an outer join returns all rows in common and the other rows in the table that is on the outer...
August 12, 2010 at 11:50 am
stewsterl 80804 (8/12/2010)
Awesome! That works..How can I add a where clause? Once I add it I dont get the results I need.
WHERE Sales.FISCAL_YR = 2008
If you put it into the...
August 12, 2010 at 11:38 am
You'll also need to get SERVICE from the Service table in the select list or it will also be NULL.
SELECT service.SERVICE, Sales.FISCAL_YR, Sales.R_UNITS, Sales.R_SALES, Sales.A_UNITS, Sales.A_SALES, Sales.I_UNITS, Sales.I_SALES
FROM Sales RIGHT...
August 12, 2010 at 11:24 am
SELECT Sales.SERVICE, Sales.FISCAL_YR, Sales.R_UNITS, Sales.R_SALES, Sales.A_UNITS, Sales.A_SALES, Sales.I_UNITS, Sales.I_SALES
FROM Sales RIGHT OUTER JOIN
SERVICE ON Sales.SERVICE = SERVICE.SERVICE
August 12, 2010 at 11:20 am
I have had my own issues with tables that are disproportionately larger than the rest of the data tables so I sympathize. The tack I took to mitigate this...
August 12, 2010 at 11:14 am
Viewing 15 posts - 331 through 345 (of 495 total)