Viewing 15 posts - 5,461 through 5,475 (of 6,676 total)
Nope - the linked server will only use the x64 ODBC drivers. What system are you trying to connect to?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 1, 2009 at 10:17 am
You are welcome - and thanks for the feedback.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 1, 2009 at 10:04 am
You are welcome - and thanks for the feedback. It is appreciated.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 5:33 pm
These types of issues are not for client systems accessing SQL Server. Your clients will use whichever ODBC client software they need to on their systems, either 32bit or...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 3:03 pm
Be aware that UNION also has to remove duplicates, which is going to take longer to process. If you can guarantee that each query is unique - you can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:56 pm
Maxer (3/30/2009)
HOWEVER, I was running it against an SQL Server 2000 data source.
That is VERY interesting to know, thank you for that!
I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:47 pm
Florian Reischl (3/30/2009)
Just a little typo in step 2):SELECT TOP (@Num) * FROM dbo.YourTable;
or
SELECT TOP (@Num) col1, col2, colN FROM dbo.YourTable;
Greets
Flo
Thanks Flo - that's what I get for typing this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:39 pm
Jerry Hung (3/30/2009)
Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008SQL 2005 SSMS cannot connect to SQL 2008
Not quite true - you can connect to SQL...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:35 pm
There is no way to upgrade an existing instance to a clustered instance. You have to build the cluster and then install a new instance into the cluster.
The only...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:30 pm
BTW - when they say SQL Server can only use 4 CPU's - they are talking about slots. A single quad core processor is one CPU's as far as...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:20 pm
What you can do in SSRS is:
1) Create a parameter for your report - let's call it TopNum
2) In your Dataset, do the following:
DECLARE @Num int;
SET @Num = @TopNum;
SELECT TOP...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:08 pm
Grant Fritchey (3/30/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 1:38 pm
MERGE was introduced in SQL Server 2008 - are you on that version?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 29, 2009 at 4:01 pm
I've already got plenty here in my own little slice of south CA. I think its just about 80 here right now.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 28, 2009 at 2:20 pm
sqlblue (3/28/2009)
you're probably right, i doubt that the forum allow attachement.but can i just copy the code you have here and put it in a
class, compile it and use it?
The...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 28, 2009 at 9:41 am
Viewing 15 posts - 5,461 through 5,475 (of 6,676 total)