Viewing 15 posts - 6,091 through 6,105 (of 9,712 total)
Ninja's_RGR'us (4/13/2011)
This thread is not how can I make this work, it's about why the heck does this concat take so long.
Ninja, I only asked because I thought the concat...
April 13, 2011 at 5:21 am
Craig Farrell (4/12/2011)
Chad Crawford (4/12/2011)
Craig Farrell (4/12/2011)
April 13, 2011 at 4:28 am
ALZDBA (4/13/2011)
I'm infected too 😀
That is an adorable avatar!
April 13, 2011 at 4:21 am
Craig Farrell (4/12/2011)
April 13, 2011 at 4:17 am
Sean Lange (4/12/2011)
Brandie Tarvin (4/12/2011)
RE: datatypes discussion
April 13, 2011 at 4:13 am
Silly question, why not stick the results into a Temp table, then haul out the commands on a line by line basis, since you have so many tables to deal...
April 13, 2011 at 4:12 am
thulani.moyana 79207 (4/12/2011)
To Brandie: I think the remote connection timeout is used by the SSMS when connecting to other servers not the application. Please verify.
So far as I know, a...
April 13, 2011 at 4:08 am
CirquedeSQLeil (4/12/2011)
Brandie Tarvin (4/12/2011)
April 12, 2011 at 12:16 pm
Hey, Ninja, I just realized that Varchar(MAX) isn't big enough to handle a database with a lot of tables. I've tried it on two of my "larger" databases (object-wise, not...
April 12, 2011 at 12:08 pm
I'm curious. Why does a simple concat need variable = variable + string logic? I only ever use that when I'm COALESCING or looping (Cursor or While).
What are you...
April 12, 2011 at 12:03 pm
The context is this:
RE: datatypes discussion
April 12, 2011 at 8:09 am
WayneS (4/12/2011)
Brandie Tarvin (4/12/2011)
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
...
April 12, 2011 at 7:53 am
You probably didn't see my edited comment.
Check the Server / Instance's "remote query timeout" property. This can be found by right-clicking the server\instance name, navigating to Properties, the clicking on...
April 12, 2011 at 7:52 am
This .net application, is it making a Web Service call or is it a direct programmed connection string?
Is there a firewall between the PC this app runs on and the...
April 12, 2011 at 7:37 am
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE...
April 12, 2011 at 5:58 am
Viewing 15 posts - 6,091 through 6,105 (of 9,712 total)