Noticed that the ClassCode values have a slash in the same position which may indicate that the column can be decomposed, such as the values before the slash indicate the...

Since the SQL Server belongs to the client, the client will have at least one login with SQL Server sysadmin rights, and a sysadmin login cannot be restricted, there is...

FYI: If you "DENY VIEW ANY DATABASE" for a login, under the SSMS object browser, only the master and tempdb databases will appear.

"Is that possible?" No, restricting the list of database displayed by SSMS is not supported. There are many requests to restrict the list of databases to only...

Sorry,my mistake - stated "RANK", which will not work ! You need to use ROW_NUMBER.

SELECTROW_NUMBER ( ) OVER (ORDER BY name ) AS NameId

,name

INTO#temp

FROMsys.objects

WHEREname NOT LIKE '#%'

SELECT*

FROM#TEMP

ORDER BY NameId

Rather than try to figure out when identity values will or will not be sequentially assigned based on an ORDER BY, suggest using RANK, which always produces a sequence with...

The case that the rows are inserted in an order that matches a specificed "order by" clause is coincidental and is documented in Books OnLine

When used together with a SELECT...INTO...

Jeff Moden's comment got me thinking about a similar question.

Based on the business rules, if "Peter" considers "Paul" a "friend" , does this mean always mean the reverse is true...

Have you set the processor affinity for intranet site? See http://www.iishacks.com/index.php/2007/05/18/setting-processor-affinity-permanently/

Once you have determined which cpu to use for the intranet site,then you can un-assign this CPU from SQL Server.

in...

Just a matter of reaching into the bag of tricks:

Set up a test environment - note that the ImageId column allows gaps:

CREATE TABLE MyImage

( ImageIDINTEGER NOT NULL

, ImageName VARCHAR(255) NOT...

Your new SQL Server is at a lower version than the old SQL Server and database restores cannot be performed to a lower version.

You can get the version of the...

This behavior is documented by MS titled "Backing Up and Restoring a Database (Sync Services)" at http://msdn.microsoft.com/en-us/library/bb726016.aspx

To get the top 6 other products on the same order as a given product:

SELECTtop 6

,ProductOrderOther.ProductId

,COUNT(*)as ProductOrderOtherCnt

FROMOrderItems

JOINOrderItemsAS ProductOrderOther

on ProductOrderOther.OrderId = OrderItems.OrderId

and ProductOrderOther.ProductId OrderItems.ProductId

WHEREOrderItems.ProductId = 123

GROUP BY ProductOrderOther.ProductId

ORDER...

In May 2009,Adam Machanic had a contest to develop the most efficient solution to a problem named "Grouped String Concatenation" that corresponds to your problem. The contest and solutions...

No you do not need to...