tempDB

RE: Sorting of 2 columns

• by DAVNovak

• MSSQLTips.com

• Reply

You need to put the DESC keyword on both columns in your ORDER BY clause. i.e. select * from table order by col1 desc, col2 desc

2003-06-26

RE: Clustering

• by barcoder

• SQLServerCentral.com

• Reply

We have been investigating setting up an active/active cluster. We have identified that cross database chaining is not intended to work across two separate servers. This may be an issue, depending on how tightly security is locked down on the database. We are going for execute permissions only on stored procedures and this policy must […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-17

RE: xp_sendmail

• by bj007

• TechNet Blogs

• Reply

Thats what I want to do. It is really hard to get a window to do it in my production. I did in one of my test servers, and it works. Why does it need to be with the same account? Do I need to create a profile in outlook for it?

2003-06-11

RE: What makes a good developer?

• by Crispin

• SQLServerCentral.com

• Reply

Serious though, looking for a solution. Google. There are plenty people who have had the same problem you have. This is how I found SQLServerCentral. A guy started working here who had never heard of google. He asked was it good. To demo it, I searched on "How do I wipe my @55" I, yes […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-11

RE: IMPORTING AN ASCII TEXT FILE DAILY

• by r_achar

• SQLServerCentral

• Reply

Here is my two cents: Whenever a system receives data from External sources, it is prudent to do a validation (sanity check) on the data before loading it to your production database. I have not used the DTS service. Does it have this capability? If not, I think, you will be better off using a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-11

RE: Changing Null to Not Null

• by James Travis

• JumpStartTV

• Reply

Because most everything done the EM actualy duplicates the table and moves the data into it, then drops the old and renames the new, all the while making sure triggers, permissions, yadayadayada, stay intact. On large tables it general is better to go the TSQL route with ALTER TABLE with these types of situations.

2003-06-05