Viewing 12 posts - 1 through 12 (of 12 total)
Since receiving a high blood pressure warning from my doctor 2 years ago, I have tracked every step I take during the day, every bit of food (with rare exception)...
November 14, 2014 at 1:25 pm
Steve Jones - SSC Editor (4/11/2014)Tracy, take it.
Steve Jones - SSC Editor (4/11/2014)
Alrighty then, consider it taken...
April 12, 2014 at 9:12 am
It this hasn't been claimed yet, I'd like to take it. I'm working quite a bit with Powershell and formatted output right now, this would fit nicely...
April 10, 2014 at 4:04 pm
Depends on the role I'm playing.
To function purely as a DBA, I don't need anything more than SSMS. In fact, for years I thumbed my nose at any third-party tools,...
January 10, 2014 at 5:54 am
January 19, 2012 at 8:09 am
Marios Philippopoulos (1/18/2012)
How is that possible without ending up in a burnout?...
January 18, 2012 at 5:32 pm
Rather than scramble to keep up with all of the new, sometimes obscure, features that new versions of SQL Server bring, I've worked to position my self as the guy...
January 17, 2012 at 7:21 pm
I've actually used INTERSECT and EXCEPT quite a bit, not as a replacement for inner joins as some of these comments imply, but to simplify the comparison of two complex...
December 24, 2011 at 8:27 am
To connect to it from within Query Analyzer, have a look at OPENROWSET. If this will be a permanent need, also look into using a linked server.
January 6, 2006 at 7:28 am
Is the domain account that SQL is using in the same domain as the logins that are attempting to connect to it?
January 4, 2006 at 7:29 pm
Very easy to do...
CREATE TABLE #temp (
INSERT INTO #temp
EXEC master..xp_cmdshell 'DIR /B C:\WINDOWS'
SELECT * FROM #temp
January 2, 2006 at 11:00 am
December 9, 2005 at 5:43 pm