Viewing 15 posts - 11,986 through 12,000 (of 26,486 total)
Because the default instance uses port 1433. This is the default when installing SQL Server using all defaults. I haven't tried installing the default instance to use a...
May 14, 2012 at 3:38 pm
sqlfriends (5/14/2012)
installed, will they exist side by side, or 2008R2...
May 14, 2012 at 3:26 pm
dan-572483 (5/14/2012)
May 14, 2012 at 2:58 pm
Between the time it was hidden and the time it wasn't, what had you done in SSMS? At anytime did you access the hidden instance?
May 14, 2012 at 11:54 am
Steve Jones - SSC Editor (5/14/2012)
May 14, 2012 at 11:23 am
I'd have thought more people would have gotten this one right. Only 60% at this time, sorry but that's low for this question imho.
May 14, 2012 at 11:09 am
Geoff A (5/14/2012)
Q1: Why were table variables introduced when temporary tables were already available?
A1: Table variables have the following advantages over temporary tables: •As mentioned in the SQL Server...
May 14, 2012 at 10:51 am
Geoff A (5/14/2012)
or even better, declare a table variable.declare @temp table (MyColumns varchar(128),......)
insert into @temp
exec usp_myprocedure
I have to ask, what's better about a table variable?
May 14, 2012 at 10:44 am
michael vessey (5/14/2012)
Lynn Pettis (5/14/2012)
May 14, 2012 at 10:39 am
dndaughtery (5/14/2012)
I need to load a temp table with the result set from a sproc sort of like the following:Select into #Temp
Exec usp_LoadTemPTableSproc
How can I do this?
Close. The temp...
May 14, 2012 at 10:30 am
JamesMorrison (5/14/2012)
Many lack the understanding of the real goal of the interview.
Often it becomes more...
May 14, 2012 at 9:53 am
Going with the "it depends" answer. How many files are being processed, how often are they processed, how big is each file that is being processed, how long does...
May 14, 2012 at 9:30 am
Without the DDL for the tables (including index definitions), sample data, expected results, your current code, and the actual execution plan(s) as .sqlplan files (ie, the graphical representation) there really...
May 14, 2012 at 9:26 am
durai nagarajan (5/14/2012)
Thanks for your reply.
What about this users listed below, why they require access to SQLserver/databases. what is the impact if i remove the access from SQL server?.
NT...
May 14, 2012 at 7:53 am
anthony.green (5/14/2012)
Not to worry, happy to help as always. Glad its working for you.
Unfortunately, it still isn't accurate. Today is 2012-05-14, how old is someone today that was...
May 14, 2012 at 7:34 am
Viewing 15 posts - 11,986 through 12,000 (of 26,486 total)