Viewing 15 posts - 3,796 through 3,810 (of 8,416 total)
CirquedeSQLeil (4/19/2010)
Simple subject - sp_who2. Hoping it will be worth the read and effort.
By the by, are you aware of sp_WhoIsActive?
I use it a lot.
April 19, 2010 at 7:09 pm
CirquedeSQLeil (4/19/2010)
I am putting the finishing touches on draft 1 of a new article. Anybody out there willing to give it a review?
What's it about?
April 19, 2010 at 5:39 pm
David Walker-278941 (4/19/2010)
April 19, 2010 at 5:26 pm
Mike and Green Clay:
Yes the ORDER BY in the CROSS JOIN example should be as you say - oddly it is only the image in the article that has this...
April 19, 2010 at 5:24 pm
Michael Valentine Jones (4/19/2010)
:Whistling:
SELECT @Date+1+88*(@date%100/12)
:laugh: :laugh: :laugh: :laugh: :laugh:
Nice one.
April 19, 2010 at 4:55 pm
Jeff Moden (4/19/2010)
Or, you can just do it in T-SQL and not have to worry about it much. 😉
It depends. If you only have a few files to process...
April 19, 2010 at 12:49 am
The older LOB data types (text, ntext, and image) are always stored off-row, by default, though this behaviour can be modified by the 'text in row' table option. The...
April 19, 2010 at 12:41 am
shyam.oec (4/15/2010)
no that did't solved my problem.equivalent problem is solved in oracle through the query that i have initially posted .Then how to solve it in SqlServer?
Same query - you...
April 18, 2010 at 11:35 pm
SQL Server provides extensive built-in support for encryption, there's no need to roll your own.
See Cryptographic Functions (Transact-SQL)
Also, if you were to implement some kind of custom routine like this...
April 18, 2010 at 11:24 pm
T-SQL is not the optimal choice for parsing text files - and IIS logs in particular.
Microsoft provide a specific tool for this purpose - Log Parser.
I once had to analyse...
April 18, 2010 at 11:17 pm
A CTE-less alternative:
UPDATE Grouped
SET CorrespondingProjectName = Grouped.ProjectInstanceName
FROM (
SELECT Instances.ProjectInstanceName,
...
April 18, 2010 at 10:58 pm
RBarryYoung (4/18/2010)
Yes, in binary. 😀
010110010110010101110011
("yes" in binary)
April 18, 2010 at 9:00 pm
Lowell (4/14/2010)
...am i just stuck with hitting sys.objects with a WHERE statement, or did i overlook something?
Yep, you're stuck with hitting sys.objects with a WHERE clause.
select * from sys.objects where...
April 18, 2010 at 8:53 pm
Always nice to find that I've answered a thread before I've seen it :laugh:
Thanks, Cold Coffee!
April 18, 2010 at 8:46 pm
My recommendation would be to redesign the table to use a more relational form.
http://databases.about.com/od/specificproducts/a/firstnormalform.htm
April 18, 2010 at 8:28 pm
Viewing 15 posts - 3,796 through 3,810 (of 8,416 total)