Viewing 15 posts - 1 through 15 (of 51 total)
"Since the SQLCLR works by mapping data from the result set to the target table by column name, the order of the columns doesn’t matter, nor does the number. If...
February 8, 2016 at 7:44 am
Your article is incomplete without adding that a SELECT INTO is considered a DDL statement and completely locks both source and target tables for the duration of its operation. ...
June 9, 2015 at 7:31 am
Simon Liddle (1/29/2010)
Irish Flyer (1/29/2010)
When you open a new query window, an immediate @@ROWCOUNT will always return a 1. This is an incorrect return
Sorry to split hairs, but I...
January 29, 2010 at 7:32 am
The answer is absolutely 1,1 because of the way the question was asked. It does not mention anything about a pre-used query window. When you open a new...
January 29, 2010 at 7:16 am
VRR (11/25/2009)
November 25, 2009 at 2:54 pm
I agree with Jeff, this is a very bad idea. Generally speaking, with any version of SQL Server starting with 2005 it is very difficult to shrink a tempdb...
November 25, 2009 at 7:52 am
That is exactly why you never let the public internet crowd access a DB server. The DB server remains inside the firewall while the web server resides in the...
November 20, 2009 at 1:27 pm
You want to explain why there are no roles in Windows and there is roles in SQL Server from the time I have been using it which is 7.0 and...
November 20, 2009 at 1:08 pm
DoD is not wasting anything here. I did not go into all steps to secure, only those that are easy. By the way, when creating a new login...
November 20, 2009 at 10:45 am
You can certainly define only SQL Server IDs, but not remove the capability to define Windows Authenticated users.
November 20, 2009 at 10:31 am
SQL Server is fully integrated with Windows for security purposes and as you know, only runs on a Windows system. You cannot remove Windows authentication without completely destroying the...
November 20, 2009 at 10:29 am
Windows authentication is way more than that. You can specify a user as SQL Server authenticated and give them a unique ID and password just for that SQL Server...
November 20, 2009 at 10:25 am
Removing Window Authentication is exactly the opposite of securing the instance. DoD only allows SQL Server authentication for those cases where it is mandatory, such as service accounts (the...
November 20, 2009 at 8:58 am
Just for the record, we have a multi-platform shop mixing SQL Server 2005/8 servers with Oracle. I have also linked SS2K5 to UDB/DB2 and Teradata.
The only one of those...
October 2, 2009 at 8:39 am
Viewing 15 posts - 1 through 15 (of 51 total)