WayneS

Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 5,588 total)

RE: Stored Proc with table variables running very slow?

Jeff Moden (1/29/2010)
I forgot about that and that's very true. Have you ever seen code that does that, though?
Another use is in auditing... if you want to audit 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

February 1, 2010 at 1:21 pm

#1111918
RE: Extract X and Y coordinates out of a string and check if within range

Charlottecb (1/30/2010)
Wayne, I've tried running your code but it doesn't seem to give the correct splits in values - It may be me doing something wrong though.
Charlotte,
It wasn't you... 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

January 31, 2010 at 7:48 pm

#1111400
RE: Enforcing multiple columns updated thru trigger

AVB (1/29/2010)
I'm not quite sure how to do this with a trigger. I can't get the Modified value from the Inserted table because there is already data in the "Modified"...
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

January 29, 2010 at 5:18 pm

#1111075
RE: Extract X and Y coordinates out of a string and check if within range

Charlotte,
First, I want to thank you for providing DDL/DML to show what your working with.
Now, this just expands on what you've started.
--===== Split or "Normalize" the whole table at once
;WITH...
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

January 29, 2010 at 5:00 pm

#1111072
RE: PK Questions

Steve Jones - Editor (1/29/2010)
Especially if there are edits to the PK, which can happen.
Ideal world: the columns that define a PK will NEVER, EVER be changed.
Real world: invariably, some...
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

January 29, 2010 at 4:27 pm

#1111068
RE: SQL2005 32 bit to 64 bit migration path

Lynn Pettis (1/29/2010)
.... You should also script out all jobs in msdb. Probably all the logins (sans passwords) in master as well. You will have to deal...
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

January 29, 2010 at 4:18 pm

#1111065
RE: Stored Proc with table variables running very slow?

san43 (1/29/2010)
We have a stored procedure which was running fine from 5 years but now it is running very slow. It is using table variables to load data from select...
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

January 29, 2010 at 11:58 am

#1110922
RE: Concatenation Issue

stricknyn (1/29/2010)
This should be pretty straightforward, but for some reason its not working and I can figure out why.
I included the SELECT portion. The error I get is
Msg 102,...
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

January 29, 2010 at 11:34 am

#1110912
RE: Count number of columns in a CSV file

I haven't used OpenRowSet to open up a csv file before. You may need to use OpenDataSource instead.
In the meantime, here's the sp_OA method:
declare @FileName varchar(100)
set @FileName = '<Put your...
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

January 28, 2010 at 8:12 pm

#1110430
RE: Bit by bit

Bhavesh_Patel (1/27/2010)
Points for taking ... 😛
Makes up for yesterdays (though points were awarded anyway...)
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

January 27, 2010 at 10:10 pm

#1109726
RE: Time - Need to convert varchar to time

tan110 (1/27/2010)
Thanks everyone, was able to get it working with set based statement. Had to loop through all the records.
Would you care to elaborate on how a set-based method 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

January 27, 2010 at 10:03 pm

#1109724
RE: How to know what time a table is last-updated?

As others have already mentioned, sys.tables will show the time the structure of the table was last changed. And you will need a trigger to show when the data 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

January 27, 2010 at 9:58 pm

#1109722
RE: Count number of columns in a CSV file

The can think of of two ways:
select *
into #temp
from OpenRowSet(...)
where 1=2
select count(*)
from tempdb.sys.columns
where object_id = object_id('tempdb..#temp')
drop table #temp
and use sp_OA...
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

January 27, 2010 at 9:38 pm

#1109719
RE: Passing table variable or temp table as input parameter

arctica82 (1/27/2010)
I am working with SQL SERVER 2000,Is it possible to Pass table variable or temp table as input parameter to stored procedure?
Not in SQL 2000.
Can I define 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

January 27, 2010 at 9:30 pm

#1109718
RE: Are the posted questions getting worse?

CirquedeSQLeil (1/27/2010)
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should...
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

January 27, 2010 at 6:54 pm

#1109693

Viewing 15 posts - 4,831 through 4,845 (of 5,588 total)