WayneS

Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 5,588 total)

RE: how to apply sp2 on active/active node in sql 2008

Have you tried the documents related to installing the SP on MicroSoft's site? What have you tried?
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

November 19, 2010 at 7:27 am

#1253049
RE: Are the posted questions getting worse?

jcrawf02 (11/19/2010)
WayneS (11/18/2010)
bitbucket-25253 (11/18/2010)
[Jeff Moden
Posted Today @ 10:13 PM
Jeff when the heck do you manage to get some sleep? ? ? ?
That's nothing... I've...
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

November 19, 2010 at 7:17 am

#1253032
RE: Are the posted questions getting worse?

bitbucket-25253 (11/18/2010)
[Jeff Moden
Posted Today @ 10:13 PM
Jeff when the heck do you manage to get some sleep? ? ? ?
That's nothing... I've seen posts...
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

November 18, 2010 at 9:07 pm

#1252842
RE: comma Separted Value

You're welcome. Does it meet your needs? And, do you understand what it's doing?
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

November 18, 2010 at 9:05 pm

#1252841
RE: how to apply sp2 on active/active node in sql 2008

You will need to install SP2 on each node. When installing, you can select which instances to apply it to - you would normally select all. (I just went through...
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

November 18, 2010 at 9:01 pm

#1252839
RE: FLATTEN OUT ROW BASED STRUCTURE TO COMMA DELIMITED

BaldingLoopMan (11/18/2010)
For some reason simply putting the “for xml” makes my brain not want to learn it.
If you don't understand what's going on, just ask. This "FOR XML" "trick" 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

November 18, 2010 at 5:45 pm

#1252813
RE: SQL Query - Number of days between two dates, grouped by month

Thanks, glad it works for you (but hey... I did test it... would you really expect it to not work as desired?)
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

November 18, 2010 at 5:26 pm

#1252808
RE: column value balancing (copy previous value <> NULL)

Dick Herberts-320552 (11/18/2010)
Hi Wayne and other techies,
Today i tested Wayne's routine on a table with 20.000.000 records. In total 6 columns are calculated and updated by Wayne's routine and 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

November 18, 2010 at 5:19 pm

#1252805
RE: column value balancing (copy previous value <> NULL)

Jeff Moden (11/17/2010)
Don't be surprised if you find the method works on heaps, as well.
Nice job, though, guys. 🙂
Heh... we learned from the master! :w00t:
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

November 17, 2010 at 10:27 pm

#1252274
RE: comma Separted Value

This should handle it for you...
SET DATEFORMAT DMY; -- to handle the format of your dates
-- See how you start off by actually creating a table
-- and then inserting the...
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

November 17, 2010 at 8:40 pm

#1252253
RE: Associating Gaps with a date and a ID

Blocks = # of hours for the gap?
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

November 17, 2010 at 7:49 pm

#1252248
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/17/2010)
I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to be deployed. Communication,...
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

November 17, 2010 at 7:32 pm

#1252245
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

MM -
Looks interesting. It will take more investigation.
I have some initial questions:
--===== Get the rowcount - this is vital - it must not exceed the actual rowcount.
1. So, what...
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

November 17, 2010 at 7:21 pm

#1252244
RE: column value balancing (copy previous value <> NULL)

LutzM (11/17/2010)
And you seriously don't have a minute to wait for the result? 😉
He doesn't think it will finish that fast... won't he be in for a surprise in the...
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

November 17, 2010 at 4:01 pm

#1252205
RE: column value balancing (copy previous value <> NULL)

LutzM (11/17/2010)
@Dick: VERY IMPORTANT!!!
Based on your previous note "4. No clustered index yet " Do NOT run the code until you added a clustered index that supports the order the...
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

November 17, 2010 at 3:25 pm

#1252188

Viewing 15 posts - 2,371 through 2,385 (of 5,588 total)