Viewing 15 posts - 4,486 through 4,500 (of 5,394 total)
I don't think it's (only) a matter of choosing the appropriate isolation level, but, according to your description of the problem, looks like there's some commit/rollback instruction missing on the...
April 8, 2010 at 6:09 am
I suggest that you use fixed port numbers and set SPNs for those ports.
April 8, 2010 at 4:04 am
Jeff Moden (4/7/2010)
CirquedeSQLeil (4/7/2010)
You know, it is article worthy. I would like to see an article on what made you decide to implement that method and performance factors etc.
I...
April 8, 2010 at 2:59 am
WayneS (4/7/2010)
As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the sooner the kids learn.
So...
April 8, 2010 at 1:51 am
CirquedeSQLeil (4/6/2010)
Jeff Moden (4/6/2010)
Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631It seemed to perform the fastest on my machine.
I...
April 7, 2010 at 8:19 am
Thank you Steve and everybody. 🙂
I was away for some days and I came back today with tons of new things in my "fix-it-right-away" list (I'm sure you have one),...
April 7, 2010 at 8:17 am
You're welcome.
Glad I could help.
April 7, 2010 at 2:49 am
Paul White NZ (4/2/2010)
Gianluca Sartori (4/1/2010)
It would be a great time saver if only uppercase names...
April 7, 2010 at 1:32 am
TheSQLGuru (3/26/2010)
Will you be iteratively (and by iteratively I mean 5+ perhaps) hitting the temp table?
I have found in some cases that taking off a copy to a temp...
April 2, 2010 at 6:13 am
At this point I wonder why case-sensitive servers allow creating linked servers with non-uppercase names.
It would be a great time saver if only uppercase names were allowed.
April 1, 2010 at 10:05 am
April fools?
Do you really want somebody to answer this, posed this is a question?
Take a look at the link in my signature, you'll find the right way to ask a...
April 1, 2010 at 9:30 am
This is the closest query I could come up for your requirement:
SELECT a.name,
description,
owner,
...
April 1, 2010 at 7:45 am
And what about renaming the linked server uppercase?
If you still need the CamelCase name, add a new one all uppercase.
April 1, 2010 at 6:28 am
Wildcards are expanded only for the right operand of the LIKE operator.
It works exactly the same in SQL Server, it's not Oracle specific:
DECLARE @TABLE TABLE (
COL1 VARCHAR(10),
COL2 VARCHAR(10),
COL3 VARCHAR(10)
)
INSERT INTO...
April 1, 2010 at 6:23 am
Viewing 15 posts - 4,486 through 4,500 (of 5,394 total)