Viewing 15 posts - 16 through 30 (of 117 total)
The standard behavior here is that an order by clause is only required to be honored by SQL Server _for the outermost select statement in a query_ or in cases...
October 5, 2006 at 9:50 am
Rather than inserting all the records including the duplicates, might I suggest doing that into a staging table, then using this process:
1. Add a unique index to the "real" table...
October 4, 2006 at 9:58 am
GREAT tip. Flashblock killed it nicely, and other animations which I found merely distracting.
October 4, 2006 at 9:10 am
Thank you for your efforts to help me out. I appreciate it.
I thought so too, and had read that very document, but when pressed for details, both our VAR and...
October 3, 2006 at 1:53 pm
Hi -
You can transfer logins with the procedure sp_help_revlogin, which you will find in a MS KB article; just search microsoft.com for that text, or for "moving SQL Server databases".
The...
October 3, 2006 at 12:36 pm
The confusion is that between Windows 2000 and 2003, they changed the policy about what consitiutes "authentication" kicking in the OS CAL requirement. The OS license itself was always required,...
October 3, 2006 at 11:06 am
Colin -
If one wanted to dedicate over 4GB of RAM to SQL Server (maybe with 64 bit OS or using AWE) then isn't Windows Server 2003 EE required? Or can...
October 3, 2006 at 9:47 am
I need to clarify one thing: I'm aware of the SQL server per-processor license type, and the language referenced above, and we've talked to MS directly. The issue, specifically, is...
October 3, 2006 at 9:42 am
Bad news: my take on this was just confirmed by a colleague in a call with MS. If you have SQL Server running on Windows 2003 Server, then an OS...
October 2, 2006 at 11:22 am
I also thought so, and that was true with Windows 2000 as far as I can tell, but with Windows 2003 Server it appears that they have changed the licensing...
October 2, 2006 at 9:52 am
Some more info, but still ambiguous:
http://www.microsoft.com/sql/howtobuy/faq.mspx
See:
"Q.What exactly is a processor license and how does it work?
"A.A processor license gives you the right to install any number of...
September 29, 2006 at 4:39 pm
That sounds great - can you perchance point to a document on MS web site that says so? I can't find anything like that.
September 29, 2006 at 4:11 pm
Another question:
"SQL Server Central ... Welcome to the largest Microsoft SQL Server community on the web with 371,536 registered members... "
What does a site like this one do, if it...
September 29, 2006 at 12:37 pm
Lynn - I'm not so sure; check this language carefully, from
http://www.microsoft.com/windowsserver2003/howtobuy/licensing/priclicfaq.mspx:
"Q.The End User License Agreement states that CALs are required for access or use of the server...
September 29, 2006 at 9:51 am
September 28, 2006 at 3:57 pm
Viewing 15 posts - 16 through 30 (of 117 total)