WayneS

Forum Replies Created

Viewing 15 posts - 4,801 through 4,815 (of 5,588 total)

RE: Red Gate's SQL Search

It works on my 64-bit 2K8
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 5, 2010 at 6:55 pm

#1114879
RE: Are the posted questions getting worse?

The Dixie Flatline (2/5/2010)
I loved the touch of Ella, bb.
Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.
"SSC ... it's not 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

February 5, 2010 at 6:54 pm

#1114878
RE: Are the posted questions getting worse?

GilaMonster (2/5/2010)
I'm contemplating a blog post on the recovering historically deleted data with DBCC TimeWarp (with all 137 non-optional parameters). Maybe for the beginning of April...
Hey Steve... If us "Thread-izens"...
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 5, 2010 at 4:34 pm

#1114847
RE: Excel source having more than 255 characters

itzmee (2/5/2010)
Hi, Thanks for your reply. Please explain how to do that..
Right-click your Excel Source, and select "Show Advanced Editor".
Go the the "Input and Output Properties" tab.
Expand the "Excel Source...
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 5, 2010 at 4:26 pm

#1114845
RE: Add value to return result set.

ronaldkrex (2/5/2010)
I was just going to tell you I figure it out. You have Been very very helpful. Thank you so much. What do I do to vote for 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

February 5, 2010 at 4:19 pm

#1114841
RE: Effects of changing domain name

The only ramification I can think of is what you've already stated: all of the domain accounts that services run under will need to be changed. Not trivial; but not...
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 5, 2010 at 11:22 am

#1114659
RE: Excel source having more than 255 characters

by default, excel text fields have a max length of 255 when importing. If using larger than this, you'll need to set up that field as a memo and not...
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 5, 2010 at 10:57 am

#1114633
RE: Table Variable Issue

I get that SQL keeps statistics on temp tables, but no on table variables. But I'm not clear how statistics on my temp table (or lack thereof on my table...
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 5, 2010 at 9:58 am

#1114582
RE: Display values in row wise

Does this do what you want?
select top 26 replicate(char( row_number() over (order by object_id)+64),3)
from sys.objects
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 5, 2010 at 9:52 am

#1114579
RE: how to write a query which must identify a particular word from one table and another table

If you want the word, then try putting a space before/after the wildcards.
To handle the situation when this word would be at the beginning/ending of the column, add a beginning/ending...
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 5, 2010 at 9:43 am

#1114570
RE: t-sql 2 cursors to populate 2 variables

Chris,
Close, but you haven't given us quite enough information yet. Please provide DDL (CREATE TABLE) for the tables, and DML (INSERT INTO) statements to make and populate the tables. See...
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 5, 2010 at 9:37 am

#1114568
RE: Are the posted questions getting worse?

lmu92 (2/4/2010)
I talked to my friend and he forwarded the info to his IT folks.
I personally feel that this was the proper course of action for you to take. 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 4, 2010 at 1:26 pm

#1113984
RE: Column With Multiple Values

@jeff - thinking outside the box again...:smooooth:
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 4, 2010 at 9:47 am

#1113831
RE: Create a table from a table of data definitions

Try this. Also, see the first link in my signature.
-- first, make a table and populate it with some sample data.
-- when you do this, all of the volunteers on...
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 4, 2010 at 9:29 am

#1113821
RE: Column With Multiple Values

Ruprecht (2/3/2010)
Hi All,
I'm working with a third-party SQL database that uses a single varchar column to store multiple values separated by a semicolon. For instance, I have a column...
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 3, 2010 at 8:37 pm

#1113409

Viewing 15 posts - 4,801 through 4,815 (of 5,588 total)