Viewing 15 posts - 1 through 15 (of 53 total)
Why two columns one for Date and another for Time. Use datetime column for both at once.
September 4, 2007 at 9:15 am
To get the bottom using top, issue and ORDER BY Col1 DESC
The Descending will reverese the order and the top statement will grab the bottom.
September 4, 2007 at 9:11 am
Question 1 Yes.
ALTER
DATABASE [AIM] MODIFY FILE (NAME=N'tAIM_Data1',...
September 4, 2007 at 9:08 am
RESTORE from a clean backup
August 2, 2007 at 9:44 am
You're always going to have to pay the price of the backup process. Idealy you want this process to finish as quicly as possible. You can't get any faster than...
August 2, 2007 at 9:38 am
I'd go with Andy at this point. I read some where that when configuring the SQL Server services that it needs to be done through the manager. Following is the...
June 28, 2007 at 8:39 am
What if a cumstomer needs to create a report? What if two customers want to create a report at the same time? And then theirs the Auditors.
June 21, 2007 at 7:29 am
The SQL Server services are always running. If they stop their is a problem. Check both the sql server logs, and the agent logs. Also the NT logs. I would...
June 21, 2007 at 7:19 am
The first question is how much transaction data is involved in your day to day operations. In most places you'll receive an additional 2% of data so using transaction replication...
June 11, 2007 at 10:34 am
Their is not a lot of clues available so I'm going to make some assumptions and you can prove me wrong. The connection works with the computer name because you are...
June 11, 2007 at 10:24 am
Script the packages. Perform a Global replace on the server name and then run the scripts on the new server. You'll still have to update a column in a table in...
June 11, 2007 at 10:06 am
The Base line Security Analyser does a good job of flagging passwords that are not strong. And I beleive it can be automated to run.
May 24, 2007 at 8:06 am
The Embaradarro tools allow you to disable the foreign key. It'll take 5 sec's with the tool.
May 24, 2007 at 8:03 am
The one thought I have is, did someone create and enable a policy on the machine that enforces a rule that the Agent be stopped? A policy would initiate a process...
May 23, 2007 at 4:09 pm
One option, with a backup in place, is to use a reorg scenario. Unload the data to a flat file. Sort the data Descending Key sequence, build just the clustered...
May 17, 2007 at 8:12 am
Viewing 15 posts - 1 through 15 (of 53 total)