Viewing 15 posts - 166 through 180 (of 1,132 total)
There is a video regarding on how MySpace.com uses SQL Server and can be found via http://www.sqlservercentral.com/Forums/Topic652576-61-1.aspx
One of the issues that is discussed in the video was the database option...
June 24, 2009 at 9:19 am
xp_logininfo invokes Windows API and does not communicate directly with Active Directory. Message 15404 is a catch all message meaning either permission denied or resource not available. Since...
June 24, 2009 at 7:49 am
Given foreign key "Table2.Table2Id to Table2.ParentTable2Id" and "Table2.Table2Id to Table2.SourceTable2Id" , then all of the "descendants" within both of these foreign keys must be deleted. The means to determime...
June 24, 2009 at 7:06 am
Extended stored procedure xp_logininfo can list the Active Directory groups of an account. An example execution is:
exec master.dbo.xp_logininfo 'IBM-5C01DE43A36\cfederl' ,'all'
From Books OnLine:
If account_name and all are specified, all permission paths...
June 24, 2009 at 5:30 am
When you run in a transaction, could you be getting blocking on the source server?
June 24, 2009 at 5:18 am
Sorry about the delay,but the NTFS decided to misbehave on my business laptop and spent yesterday getting windows re-installed.
First, the term "Triangle Join" is a wonderfull term that easily conveys...
June 23, 2009 at 3:18 pm
There is absolutely no need to create a Tally table in Master. If you don't want to have that very useful tool in every database, you should make a Utililty...
June 22, 2009 at 8:37 am
When you state "restart it", do you mean that you turned off the power ?
Powering off a workstation could have corrupted the file system. To diagnose, go to "run"...
June 21, 2009 at 10:27 pm
I have some SQL similar to what you are trying to perform for Last In First Out inventory allocation, that may get you started.
The data has four Wharehouse and each...
June 21, 2009 at 10:21 pm
Joe Celko has written 2 article on implementing FIFO and LIFO with SQL.
June 21, 2009 at 10:37 am
For clusters, there is an intermentant bug in SP2 where the mail stored procedures are not updated. There are also a few other changes that need to be made...
June 21, 2009 at 9:30 am
Ran your two SQL statements and there are differences in both the statistics io and query plans. But the two SQL statements are not logical equivalent. The Sub-Query...
June 19, 2009 at 12:53 pm
I find that the only the checkdb maintenance plan is of any use and the other plans lack the necessary functionality. I use SQL stored procedure in the master...
June 19, 2009 at 11:07 am
Kimberly Tripp just had a blog post titled "Why aren't those nonclustered indexes being used?" that answers the question "What percentage of data IS selective enough to use a nonclustered...
June 19, 2009 at 9:03 am
There is a tradition in contract bridge, that if you win the last trick of a hand with the 7 of diamonds, your partner must buy you a beer.
June 18, 2009 at 11:46 am
Viewing 15 posts - 166 through 180 (of 1,132 total)