Viewing 15 posts - 5,851 through 5,865 (of 18,926 total)
BTW that tricks works also for years, months and days (to cut off the time out of the date).
May 22, 2011 at 6:03 pm
LutzM (5/22/2011)
There are cases where a table variable would be preferred over a temp table (e.g. to capture some values even after a rollback). Without knowing...
May 22, 2011 at 10:03 am
Just for the heck of it I'll throw in that you can use EXCEPT as well. But you must compare the same # of columns in both tables so...
May 22, 2011 at 10:02 am
The cookie cutter answer I can give you is that you must update stats so that you get the correct plans. But you obviously know that already. That...
May 22, 2011 at 10:00 am
ya thank you :hehe:.
May 22, 2011 at 9:54 am
Long story short, dynamic sql runs on a different connection. So everything you created in the proc needs to either be put in the dynamic sql via concatenation OR...
May 22, 2011 at 9:51 am
GilaMonster (5/22/2011)
Where is what stored? The definition? It's part of the procedure definition, so in the system tables. There's no separate storage, no more than...
May 22, 2011 at 9:49 am
Please do not cross-post. It fragments replies and takes longer to solve the issue.
No more replies here plz. Forward the discussions here : http://www.sqlservercentral.com/Forums/Topic1112847-1292-1.aspx
May 22, 2011 at 5:32 am
Please do not cross-post. It fragments replies and takes longer to solve the issue.
No more replies here plz. Forward the discussions here : http://www.sqlservercentral.com/Forums/Topic1112847-1292-1.aspx
May 22, 2011 at 5:32 am
The only real test is to try to connect. So I'd try a really simple select on the remote server and do a try / catch to get the...
May 22, 2011 at 5:30 am
IIRC image is just a fancy word for varbinary(max). So I'd just generate larger and larger binary files (with junk data).
You could also try the insert with the bulk...
May 22, 2011 at 5:26 am
sqldba_icon (5/21/2011)
Ninja's_RGR'us (5/21/2011)
sqldba_icon (5/21/2011)
In my case a CTE is using inside a proc, now where is this CTE stored? I thought memory? Isn't it?
At proc creation time or proc /...
May 21, 2011 at 8:48 pm
sqldba_icon (5/21/2011)
In my case a CTE is using inside a proc, now where is this CTE stored? I thought memory? Isn't it?
At proc creation time or proc / statement execution...
May 21, 2011 at 8:03 pm
So apparently my test on your other thread didn't work.
Here's what I'd do next.
Redo the insert but from sql server side in QA.
Gradually create larger binary variables and insert them...
May 21, 2011 at 7:28 am
Casts the string to nvarchar instead of default varchar
May 20, 2011 at 4:44 pm
Viewing 15 posts - 5,851 through 5,865 (of 18,926 total)