Viewing 15 posts - 4,486 through 4,500 (of 5,393 total)
I suggest that you use fixed port numbers and set SPNs for those ports.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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),...
-- Gianluca Sartori
April 7, 2010 at 8:17 am
You're welcome.
Glad I could help.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
April 1, 2010 at 9:30 am
This is the closest query I could come up for your requirement:
SELECT a.name,
description,
owner,
...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
April 1, 2010 at 6:23 am
Nice one, Steve! Ok, I have to admit you fooled me.
-- Gianluca Sartori
April 1, 2010 at 6:12 am
You could try with
select serverproperty('MachineName')
OR
select serverproperty('ComputerNamePhysicalNetBIOS')
but I can't confirm it works, because all my servers are name uppercase.
Hope this helps
Gianluca
-- Gianluca Sartori
April 1, 2010 at 6:08 am
Viewing 15 posts - 4,486 through 4,500 (of 5,393 total)