Viewing 15 posts - 1,831 through 1,845 (of 5,588 total)
Well, Joe still has his rhetoric, but it seems to have been toned down quite a bit. Almost an attempt to be humorous about it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 11:35 am
This ought to get you started...
;WITH CTE AS (
SELECT KT_ID, KT_Type, RN = ROW_NUMBER() OVER (ORDER BY KT_ID)
FROM KeyTable
)
--INSERT INTO Tens_Table (TT_ID, TT_Type, TT_Message)
select KT_ID, KT_Type, CONVERT(varchar(5), RN)...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 10:20 am
There's only a few things that would make a difference, and those mostly go to drivers. Linked servers/OpenRowset/SSIS may have issues.
With less-and-less reason to NOT use 64-bit, those vendors need...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 10:05 am
TravisDBA (1/26/2011)
WayneS (1/25/2011)
TravisDBA (1/25/2011)
WayneS (1/25/2011)
Copying code and using it: I prefer that the code comments have a link to where it was found. But,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 9:50 am
Sounds like a 3-part replace:
replace(replace(replace(Column, '.', '|'), ',', '.'), '|', ',')
I'm not sure what the SSRS statements would be :(, but you should be able to look it up if...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:44 am
SQL33 (1/25/2011)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:39 am
mister.magoo (1/25/2011)
How about using a new database and creating uniquely named tables - perhaps include the SPID in the name
This sounds like an excellent idea. I'm not sure that a...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:32 am
I only mostly agree with #8 in the referenced article. Sometimes the issues that are causing you to look are out of the bosses control - or the issues are...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:28 am
Lynn Pettis (1/25/2011)
... I have also the where the code changes work perfectly in development and during UA, but fail miserably in production.
IMHO, this would be indicative of not...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:24 am
Well, I don't see a problem with this:
1. constraints are a separate object, and are stored in the sys.objects (or sysobjects) views.
2. the scripted commands for a drop/create work for...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:18 am
Lynn Pettis (1/25/2011)
declare @TestStr varchar(128) = 'TRITON9700 L9700031288172 10-07-09 | EDC TRITON 9700 CASH DISPENSER';
select
SUBSTRING(@TestStr, PATINDEX('%[0-9][0-9]-[0-9][0-9]-[0-9][0-9]%|%',@TestStr), 8) as CharDate,
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:09 am
sys.indexes will get you a list of all of the indexes in a table.
sys.key_constraints will get you a list of all of the primary key and unique constraints, and what...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 26, 2011 at 12:05 am
PSB (1/25/2011)
TRITONRL5000 LRL5114070400714 ...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 25, 2011 at 5:21 pm
terry.lewis 52981 (1/25/2011)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 25, 2011 at 5:18 pm
TravisDBA (1/25/2011)
WayneS (1/25/2011)
Copying code and using it: I prefer that the code comments have a link to where it was found. But, most importantly......
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 25, 2011 at 5:17 pm
Viewing 15 posts - 1,831 through 1,845 (of 5,588 total)