WayneS

Forum Replies Created

Viewing 15 posts - 3,511 through 3,525 (of 5,588 total)

RE: The NONUpgrade from 2005

I have a script (at home - can get it tonight if you want it) that will script out all of the reports/data sources / data models / folders off...
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

August 30, 2010 at 10:26 am

#1213824
RE: The NONUpgrade from 2005

Dan,
The SQL 2008 Upgrade Technical Reference Guide covers this in section 14.3.2.
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

August 30, 2010 at 9:35 am

#1213800
RE: Create table with named versus un-named PRIMARY KEY

I was going to comment about the readability of error messages, but I see that Michael has beat me to it. This can be especially helpful if the error 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

August 30, 2010 at 9:03 am

#1213788
RE: Questionable SELECT Statement Length - Maybe Funny For Some of You

Wow. I've seen some pretty long ones, but I don't think it was quite that long. Then again, I usually dump mine to NotePad++, which (depending on the font used...
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

August 30, 2010 at 7:32 am

#1213709
RE: Creating dynamic sql with sp_executesql

sqlgreenhand (8/29/2010)
I would like to create a dynamic sql with sp_executesql as followed, but with errors. Please help
Do all the varchar become nvarchar ?
Thanks.
DECLARE @DatabaseName nvarchar(500)
DECLARE @TableName nvarchar(500)
DECLARE @ColumnName nvarchar(500)
DECLARE...
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

August 29, 2010 at 9:30 pm

#1213596
RE: how to get the results of a subquery as a commaseparated list

STUFF removes the leading comma.
CROSS APPLY runs the query against each record.
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

August 29, 2010 at 4:38 pm

#1213577
RE: recursive or a better way to solve this problem

SwePeso (8/29/2010)
Can one of you gurus please test this. It's something I came up with today.
Using the 116,000 rows of data from my previous post, this generates these results:
Table '#Test___00000000001A'....
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

August 29, 2010 at 4:32 pm

#1213575
RE: Parsing strings in T-sql

SQLEngine (8/29/2010)
Thanks
Isnull works, I like that.
Can't say that I understand WHERE CHARINDEX(...) > 0 syntax
This filters the result set to just those records that do have a period.
If you didn't...
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

August 29, 2010 at 1:26 pm

#1213557
RE: recursive or a better way to solve this problem

Jeff Moden (8/29/2010)
Wayne,
I was looking at your previous row calculation on the 3 part update thinking to myself "Cool... he even thought of the forced RN change when EMID...
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

August 29, 2010 at 8:07 am

#1213531
RE: scheduling stored procedure after every 30 min

Triplicate post. Please post all responses at http://www.sqlservercentral.com/Forums/Topic977057-1292-1.aspx.
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

August 29, 2010 at 6:12 am

#1213520
RE: scheduling stored procedure after every 30 min

Triplicate post. Please post all responses at http://www.sqlservercentral.com/Forums/Topic977057-1292-1.aspx.
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

August 29, 2010 at 6:11 am

#1213519
RE: scheduling stored procedure after every 30 min

Make a job. Make each sp a separate step.
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

August 29, 2010 at 6:10 am

#1213518
RE: If You Had To Pick a Super Hero...

Jeff Moden (8/27/2010)
David in .AU (8/27/2010)
Jeff, that's such a cop out 🙂
Come on, show the color of your spandex...
As for me, Atomic Robo, has a lot more fun with technology...
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

August 28, 2010 at 2:38 pm

#1213493
RE: recursive or a better way to solve this problem

WayneS (8/28/2010)
thava (8/28/2010)
this way is slow when i used a large amount of data so i want change it for that, i need a little explanation there, could you...
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

August 28, 2010 at 2:29 pm

#1213492
RE: Are the posted questions getting worse?

Hi...
My name is Wayne. My title is DBA, but I feel like I have so much to learn to be worthy of that title.
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

August 28, 2010 at 12:21 pm

#1213460

Viewing 15 posts - 3,511 through 3,525 (of 5,588 total)