WayneS

Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 5,588 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (4/13/2010)
Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.
The entity known as "The Thread" randomly deducts...
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

April 13, 2010 at 8:16 pm

#1151101
RE: Are the posted questions getting worse?

Roy - what did you think of all the April 1st jokes on this site? Steve pulled off some pretty awesome ones
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

April 13, 2010 at 9:51 am

#1150827
RE: Permission nightmare or not?

Barkingdog (4/12/2010)
I work with a dev who would lke the following permissions on several databses, on different servers (sql 2000, sql 2005, sql 2008). Is his request a reasonable one...
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

April 13, 2010 at 9:34 am

#1150816
RE: Recursive queries - get the top N quantity

steve-lauzon (4/13/2010)
Holy smokes !
Thanks a lot guys... you've just saved me a bunch of time - just the solution I was searching for
The "Holy smokes" is adequate... this routine 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

April 13, 2010 at 9:17 am

#1150803
RE: Truncate logfile on a specific time

abemby (4/13/2010)
Hi Adam
I did mention that this is done after database is backedup... i completely agree with you... may be i should have highlighted it in bold.
... >> 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

April 13, 2010 at 9:00 am

#1150788
RE: Truncate logfile on a specific time

You might want to read this article[/url] by Gail Shaw of why you shouldn't truncate logs.
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

April 13, 2010 at 8:58 am

#1150784
RE: How to Pass an array from the front end (say .NET) into a Stored Procedure?

There are a few methods, but none of them are pretty. Note that in SQL 2008, you can pass a table variable to a procedure, but since this is 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

April 13, 2010 at 8:31 am

#1150761
RE: Adding a column

You cannot add a column to a table at a specified column position; adding a column adds it to the end of the table.
If you really need this column in...
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

April 13, 2010 at 7:34 am

#1150713
RE: change datatype of a column having clustered index

You will have to:
1. drop any foreign keys in other tables referencing this index if applicable.
2. drop the index
3. change the column
4. rebuild the index
5. reinstate any foreign keys 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

April 13, 2010 at 7:29 am

#1150703
RE: Recursive queries - get the top N quantity

Matt Miller (#4) (4/12/2010)
Also - does it matter which blocks get consumed first in the case of a tie? For example - if batches 1,3,6,8 each had 100 and...
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

April 12, 2010 at 10:09 pm

#1150478
RE: Recursive queries - get the top N quantity

Jeff Moden (4/12/2010)
Heh... I was just getting ready to post a nearly identical solution. I'm pretty proud of you guys... you beat me at my own game anymore. :-P...
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

April 12, 2010 at 10:06 pm

#1150477
RE: Recursive queries - get the top N quantity

steve-lauzon (4/12/2010)
Thanks... here are the clarifications ... Does this help
Absolutely. Based on these clarifications, this will work for you.
SET NOCOUNT ON
if object_id('tempdb..#tDivision') IS NOT NULL DROP TABLE #tDivision
if object_id('tempdb..#tDivisionBloc') 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

April 12, 2010 at 9:45 pm

#1150474
RE: Recursive queries - get the top N quantity

You didn't give us all the information we're going to need in order to help you.
For instance, does "highest weight" = #tDivisionBloc.BlocWeight?
Does "Qty" = #tDivision.DivisionQty, or #tDivisionQty * #tDivisionBloc.BlocWeight?
Based upon...
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

April 12, 2010 at 5:12 pm

#1150433
RE: Are the posted questions getting worse?

Trey Staker (4/12/2010)
@Tammy --SSC is an awesome site. Don't worry about being a "newb". There isn't a person out there who hasn't been a "newb" at one point....
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

April 12, 2010 at 4:53 pm

#1150424
RE: MCJ - The Missing Link

Ran across this article proclaiming the value of becoming certified. Seems to be from the cert industry, but not entirely sure.
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

April 12, 2010 at 3:22 pm

#1150389

Viewing 15 posts - 4,441 through 4,455 (of 5,588 total)