WayneS

Forum Replies Created

Viewing 15 posts - 3,781 through 3,795 (of 5,588 total)

RE: upgrading from 2000 enterprise to 2005 standard

First, I'm going to agree with some of the things already mentioned. You do not have a direct upgrade path for what you're wanting to do, and I'd also agree...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 20, 2010 at 9:04 pm

#1195910
RE: what laptop do you use?

I have a HP DV-7.
Whatever laptop you get, ensure that you check the OS requirements for installing SQL. I had to upgrade from Vista Home to Ultimate to be able...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 20, 2010 at 8:57 pm

#1195908
RE: Are the posted questions getting worse?

The Dixie Flatline (7/16/2010)
We could start a rhyme of the day, like the random word of the day.
I'll get it started off.....
"Orange"
Someone's being a smart-a**
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2010 at 4:11 pm

#1194419
RE: Collective Intelligence

I don't know that I agree with being insecure, but I know that in spite of the vast amount that I have learned about SQL, I know that there is...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2010 at 5:37 am

#1194010
RE: What would keep scheduled jobs from running?

Steve Jones - Editor (7/15/2010)
I'd would be very curious if this worked when you failed back.
So, just to make it clear.
NodeA - Normally active node
NodeB - Normally passive node
- Jobs...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 15, 2010 at 9:32 am

#1193581
RE: Problem to convert a char(24) field to datetime

When I run this:
declare @TestTable table (CounterDateTime char(24))
insert into @TestTable
SELECT '2010-07-06 21:00:01.572' UNION ALL
SELECT '2010-07-06 21:00:31.463' UNION ALL
SELECT '2010-07-06 21:01:01.479' UNION ALL
SELECT '2010-07-06 21:01:31.479'
select CounterDateTime, IsDate(CounterDateTime) from @TestTable
I get all...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 15, 2010 at 8:52 am

#1193550
RE: Is prefixing table names with "tab" a good idea

I find this of dubious value. However, since you can also select from views and some functions, it might be of some use to do this. Personally, I assume that...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 15, 2010 at 6:34 am

#1193429
RE: What would keep scheduled jobs from running?

Well, the scheduled jobs still aren't running from the active node (which is normally the passive node - active after a failover). I'm pretty sure that if I fail it...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 15, 2010 at 6:28 am

#1193425
RE: What would keep scheduled jobs from running?

This particular cluster is a "test" cluster - the first point in our migration path where a cluster is utilized. I need to fail it back to it's normal mode...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 14, 2010 at 3:50 pm

#1193159
RE: What would keep scheduled jobs from running?

Well, I'm usually loath to go around restarting things, but stopping and restarting the SQL Server Agent from cluster administrator fixed this. I'd really like to understand a bit more...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 14, 2010 at 2:53 pm

#1193133
RE: What would keep scheduled jobs from running?

Well, cluster administrator is saying that the sql agent is running on the active node... but let me try restarting it to see how that affects things.
I also just found...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 14, 2010 at 1:39 pm

#1193098
RE: What would keep scheduled jobs from running?

Did you have a failover?
Yes, The cluster did failover.
If you connect to the Virtual clustered node, do you see the jobs/agent/service accounts the same as you might see them...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 14, 2010 at 12:05 pm

#1193032
RE: Are we in all these cities?

I have to admit that I got this correct, but for the wrong reason. In looking at the question
Using the default Northwind database on a default install of SQL...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 14, 2010 at 5:22 am

#1192678
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/13/2010)
WayneS (7/13/2010)
WayneS (7/12/2010)
Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 13, 2010 at 6:01 pm

#1192436
RE: SSIS pkgs don't run on 2nd instance on standby node

CirquedeSQLeil (7/13/2010)
Wayne,
What are the service accounts being used for SQL Server Agent? (Domain, local, or network service)
Do you have logging enabled?
Can you open and edit the maint plans? ...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 13, 2010 at 5:24 pm

#1192420

Viewing 15 posts - 3,781 through 3,795 (of 5,588 total)