WayneS

Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 5,588 total)

RE: scripts for monitoring longrunningjobs in sqlserever2000

kiranjanga2 (6/23/2009)
i am getting the error as (Invalid object name 'dbo.fn_hex_to_char'.)
kiranjanga2,
I've found the solution for your issue. However, since we're doing your work for you, it's only fair...
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

June 23, 2009 at 2:27 pm

#1014256
RE: Bookmark Lookup Options...

David O (4/9/2008)
Most of them are pretty good but you got two I'm thinking could be a problem.
If you've go the maintenance window. I'd run dbcc dbreindex against...
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

June 23, 2009 at 2:13 pm

#1014250
RE: need help transforming a table's column to rows

Jeff Moden (6/22/2009)
WayneS (6/22/2009)
Jeff Moden (6/20/2009)
Heh... they kind of did :hehe: ... take a look at the NUMBER column of Master.dbo.spt_Values where the TYPE = 'P'. I don't believe...
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

June 22, 2009 at 11:22 pm

#1013724
RE: Are the posted questions getting worse?

Lynn Pettis (6/22/2009)
How about this one? 😛
Now I'm being called a troll.
Really now, shouldn't that be Saint Troll?? 😉
Absolutely. As anyone that has followed Lynn will know, any reference...
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

June 22, 2009 at 11:19 pm

#1013722
RE: need help transforming a table's column to rows

Jeff Moden (6/20/2009)
Heh... they kind of did :hehe: ... take a look at the NUMBER column of Master.dbo.spt_Values where the TYPE = 'P'. I don't believe they ever intended...
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

June 22, 2009 at 2:46 pm

#1013589
RE: need help transforming a table's column to rows

ktlady (6/20/2009)
Wayne, I added "select * from @tmp" at end of your code. And here is the result I get from.
ColumnAColumnBTmpCol
a11:3:5:61356
a22:4:5245
Does this match the expectation?
Yes, that is what was...
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

June 22, 2009 at 2:44 pm

#1013588
RE: Converting Comma Separated value into a Table

Gatekeeper (6/22/2009)
Well, I guess I was off a bit more than I thought I was.
No problem. When I saw the way he wanting his output, I knew it was going...
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

June 22, 2009 at 2:44 pm

#1013587
RE: HOW TO OPTIMEZES THE QUERY

Without an execution plan (see the article that Lutz referenced), we can't tell. That long-distance brain-meld just isn't working, so we don't have enough information.
That being said, I would bet...
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

June 22, 2009 at 2:39 pm

#1013585
RE: IDENTITY COLUMN for #temp tbl and SEED value with variable.

You can do it without an identity column:
/*
-- replace this code
SELECT @maxvalue
select identity (int, 1,1) as Id , col1, col2
into #ABS
from #test
*/
-- with this
select row_number() OVER (Order by Col1) +...
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

June 22, 2009 at 2:25 pm

#1013580
RE: Converting Comma Separated value into a Table

Gatekeeper (6/22/2009)
This was answered 2 days ago: http://www.sqlservercentral.com/Forums/Topic738904-338-1.aspx
No it wasn't. Similiar, but yet completely different.
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

June 22, 2009 at 1:16 pm

#1013537
RE: Converting Comma Separated value into a Table

HTH
-- NOTE - putting your sample code like this helps people quickly help you!
declare @list varchar(1000)
set @list = '1,11,2,22,3,33'
-- make an XML variable to hold the list
declare @xml XML
--...
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

June 22, 2009 at 1:13 pm

#1013534
RE: Setting Value depending on condition

naveenreddy.84 (6/22/2009)
My Stored Procedure Gets a value from front end.i,e. L0, L1,L2,L3
Depening on what value is send from the front end, i need to set the value for 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

June 22, 2009 at 12:50 pm

#1013521
RE: XML Record set

Based on your XML code above, what does your expected results look like?
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

June 22, 2009 at 12:44 pm

#1013516
RE: Is xp_cmdshell Security threat???

rambilla4 (6/22/2009)
Hi,
We are using xp-cmdshell for deleting old backups. But I heard that xp_cmdshell is a big security threat for SQL Server. Is it true?
That depends. Do you consider this...
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

June 22, 2009 at 12:33 pm

#1013508
RE: Are the posted questions getting worse?

Jeff Moden (6/22/2009)
Does anyone have some apple-sauce? 😛
Strangely enough, I just picked some up last night...
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

June 22, 2009 at 12:18 pm

#1013501

Viewing 15 posts - 5,161 through 5,175 (of 5,588 total)