Viewing 15 posts - 481 through 495 (of 859 total)
crookj (4/19/2012)
SQLRNNR (4/19/2012)
styracosaurusTriceratops
High Tops
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 2:42 pm
Sean Lange (4/19/2012)
Mike01 (4/19/2012)
At least he's consistent. This is just as bad as his other post. 😀LOL!!!!
i dont know which is worse, the fact that he is consistently bad...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 2:35 pm
ScottPletcher (4/19/2012)
Did you adjust the original query so you're doing an apples-to-apples comparison?
SELECT *
FROM #myData md
CROSS JOIN #patterns p
WHERE
md.descr LIKE p.pat
still comparing the entire table 4...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 2:12 pm
roryp 96873 (4/19/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 12:21 pm
Steve Cullen (4/19/2012)
SELECT OBJECT_NAME(object_id) FROM sys.all_sql_modules
WHERE definition LIKE '%Database_A%'
This won't limit the results to database references...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 11:09 am
well there are to options, opening every SP and looking through it or something like the following may work:
SELECT SPECIFIC_NAME FROM DBa.INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%DBb%'
that will select the names...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 10:58 am
itskanchanhere (4/19/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 19, 2012 at 8:05 am
ReginaR1975 (4/18/2012)
[OrderNo] [smallint] NULL,
[Price] [smallmoney] NULL,
[Descr] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,30,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,30,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(001,40,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,20,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,30,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,50,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(002,42,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(003,40,1)
INSERT INTO [Test].[dbo].[Orders]([OrderNo],[Price],[Descr])VALUES(003,48,1)
INSERT...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 11:22 pm
ReginaR1975 (4/18/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 10:49 pm
you can only do some of those things with tsql and db mail but if you add in a web programming component you can do them all. i would...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 10:42 pm
can you post your create table statements (DDL), sample data (Hard coded inserts) and your sample output (How you want it to look). if you need some help assembling...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 10:37 pm
Lynn Pettis (4/18/2012)
C3PO's twin (4/18/2012)
Yeah I know that. But has SQL Server matured enough to be an Enterprise DBMS that can up for more than 6 months?
I am going to...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 8:24 pm
Revenant (4/18/2012)
capn.hector (4/18/2012)
EL Jerry (4/18/2012)
crookj (4/18/2012)
Lynn Pettis (4/18/2012)
capn.hector (4/18/2012)
Lynn Pettis (4/18/2012)
Childishman-boy-ish
infantile 😀
juvenile
Senile
diapers
disposables
burn phone
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 6:03 pm
The Dixie Flatline (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
My wife is a special education teacher with a lot of training and experience in behavior modification....
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 6:01 pm
EL Jerry (4/18/2012)
crookj (4/18/2012)
Lynn Pettis (4/18/2012)
capn.hector (4/18/2012)
Lynn Pettis (4/18/2012)
Childishman-boy-ish
infantile 😀
juvenile
Senile
diapers
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 18, 2012 at 4:51 pm
Viewing 15 posts - 481 through 495 (of 859 total)