Viewing 15 posts - 451 through 465 (of 3,221 total)
You might use this to find the words to replace.
CREATE PROCEDURE [dbo].[FindWordsInaSP_5K]
@Watchword varchar(50)
AS
SELECT distinct
'type' = case type
when 'FN' then 'Scalar function'
...
May 16, 2012 at 8:25 am
Hugo Kornelis (5/16/2012)
Thomas Abraham (5/16/2012)
Hugo Kornelis (5/16/2012)The only way I can reproduce what you are seeing, both on SQL Server 2008 R2 (I don't have 2008 vanilla) and on SQL...
May 16, 2012 at 7:32 am
Hugo Kornelis (5/16/2012)
(One possible...
May 16, 2012 at 5:13 am
jasona.work
Not as intensive as the annual PASS meeting, but I have found (local pass chapters) which typically meet once per month, to be a good source of information,...
May 15, 2012 at 11:33 am
All ye All ye, Now hear this
How about commenting on opc.three's post to encourage / discourage him in writing a spackle article:
http://www.sqlservercentral.com/Forums/Topic1298803-1292-2.aspx#bm1299757
May 14, 2012 at 1:14 pm
opc.three (5/14/2012)
bitbucket-25253 (5/12/2012)
opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some...
May 14, 2012 at 11:13 am
To help you, and to assist those who wish to help you with a tested answer, please, please post table definitions, some sample data for each table, and the required...
May 13, 2012 at 4:02 pm
Comment removed did not fully read the title to this posting .....
which is Msg 1828, Level 16, State 5, Line 1 The logical file name "address" is already in use....
May 13, 2012 at 10:32 am
I think you should read the following:
http://msdn.microsoft.com/en-us/library/ms143506.aspx
Pay partcular attention to the operating system requierments for SQL 2012
May 12, 2012 at 6:17 pm
opc.three (5/11/2012)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some tests. I...
May 12, 2012 at 4:19 pm
Revenant (5/11/2012)
michael vessey (5/11/2012)
as for stored procedures - well frankly if your manager doesn't know how to give you permissions to add stored procedures...
May 11, 2012 at 9:48 am
Nice question ..... and it teaches something additional ... it teaches one to read definitions as well as the T-SQL very, very closely
May 8, 2012 at 8:37 pm
May you are your family enjoy .....
May 8, 2012 at 4:43 pm
Viewing 15 posts - 451 through 465 (of 3,221 total)