Viewing 15 posts - 2,026 through 2,040 (of 3,011 total)
Windows Server 2003 supports deframentation of open files, so utilities like DiskKeeper can defragment them while SQL Server is running.
I'm not sure if you would see much improvement in performance.
February 5, 2009 at 9:58 pm
Do you have a question, or is this a trip down memory lane?
February 5, 2009 at 4:51 pm
...Michael Valentine Jones, do you mean account for Agent service, right?...
I mean both accounts. Backup and restore commands run under the SQL Server Service account.
February 4, 2009 at 4:28 pm
One thing you might need a domain account for is the ability to backup a database to a remote file share or to restore from a backup on a remote...
February 4, 2009 at 2:57 pm
Let’s start with the basics: All tables should have a primary key.
If a table does not have a primary key, it is not in first normal form. Any time...
February 4, 2009 at 10:22 am
You could do the same in one query by using your first query as a derived table.
select
b.ranking,
a.*
from
tblMemberSummary a
...
February 3, 2009 at 9:44 pm
tyang (2/3/2009)
How to manage the jobs on the Express edition?
Since there is no SQL Agent, there are no SQL Agent jobs to manage.
February 3, 2009 at 4:27 pm
Use the RANK function to do a rank within subcategory, and then select only those with a rank of 10 or less.
The RANK function is documented in SQL Server 2008...
February 3, 2009 at 4:07 pm
Backup devices are obsolete features left over from earlier versions of SQL Server.
Just backup to individual backup files with a time stamped name.
Example:
MyDBName_db_20091231_135344.bak
This is how a database maintenance plan handles...
February 3, 2009 at 4:01 pm
charlesz (2/3/2009)
"A type with unlimited max...
February 3, 2009 at 3:16 pm
LAW1143 (2/3/2009)
the bcp out has a query, and an...
February 3, 2009 at 1:25 pm
Roy Ernest (2/3/2009)
OMG, this is a great thread for entertainment purpose. 😀Did I make it to the TWIT List? I probably have.... lol. I can be such a stupid fool...
Probably...
February 3, 2009 at 12:31 pm
You should also do this to speed up the load:
1. Script out all the non-clustered indexes on the table.
2. BCP the data out in the order of the clustered index...
February 3, 2009 at 11:57 am
Did you set the BCP parameter to commit every so many rows? If not, everything is in one huge transaction, and that would explain your slow down as the...
February 3, 2009 at 10:47 am
Viewing 15 posts - 2,026 through 2,040 (of 3,011 total)