Viewing 15 posts - 121 through 135 (of 1,131 total)
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...
SQL = Scarcely Qualifies as a Language
July 29, 2009 at 3:24 am
FYI: If you "DENY VIEW ANY DATABASE" for a login, under the SSMS object browser, only the master and tempdb databases will appear.
SQL = Scarcely Qualifies as a Language
July 29, 2009 at 2:40 am
"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...
SQL = Scarcely Qualifies as a Language
July 28, 2009 at 2:23 pm
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
SQL = Scarcely Qualifies as a Language
July 23, 2009 at 11:38 am
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...
SQL = Scarcely Qualifies as a Language
July 23, 2009 at 11:34 am
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...
SQL = Scarcely Qualifies as a Language
July 23, 2009 at 7:12 am
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...
SQL = Scarcely Qualifies as a Language
July 22, 2009 at 11:58 am
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...
SQL = Scarcely Qualifies as a Language
July 22, 2009 at 11:52 am
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...
SQL = Scarcely Qualifies as a Language
July 21, 2009 at 6:34 pm
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...
SQL = Scarcely Qualifies as a Language
July 21, 2009 at 9:31 am
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
SQL = Scarcely Qualifies as a Language
July 21, 2009 at 9:04 am
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...
SQL = Scarcely Qualifies as a Language
July 21, 2009 at 3:19 am
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...
SQL = Scarcely Qualifies as a Language
July 21, 2009 at 2:34 am
so are you saying that I need to call this trigger while updating the tblJobsBR and tblJobs, not quite sure how to do that.
No you do not need to...
SQL = Scarcely Qualifies as a Language
July 19, 2009 at 8:18 am
How can I ensure the once the ActualStartDate is entered i.e. Is Not NULL anymore the ActualStartTime is also entered.
This can be enforced with a check constraint
ALTER TABLE tblJobsBR
ADD...
SQL = Scarcely Qualifies as a Language
July 18, 2009 at 7:02 am
Viewing 15 posts - 121 through 135 (of 1,131 total)