Viewing 15 posts - 24,136 through 24,150 (of 26,484 total)
Broken record time. I wouldn't waste my time reformatting stored procedures just for consistency purposes. I would spend my time on more productive efforts that will have a...
October 8, 2008 at 9:34 am
I have to deal with the same thing where I work. If I need to modify a procedure, that is when I make any changes to formatting (capitalization, indention,...
October 8, 2008 at 9:03 am
I'm waiting to see why you need to change the case of everything in your stored procs from UPPER CASE to lower case.
😎
October 8, 2008 at 8:49 am
rbarryyoung (10/7/2008)
Jeff Moden (10/7/2008)
October 7, 2008 at 11:05 pm
Here's the fall back, "it depends". How wide are the records in the heap/clustered index, how many records in the table, how many records are being returned by the...
October 7, 2008 at 2:32 pm
I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.
😎
October 7, 2008 at 1:19 pm
True, Gail. I remember, however, when SQL would ignore the indexes entirely if you started a LIKE clause with a wild card and just do a table scan. ...
October 7, 2008 at 1:17 pm
I have to agree with the other posters. I would also look at changes to the entire process over time. This procedure is RBAR (a Modenism for Row...
October 7, 2008 at 1:13 pm
mesql (10/7/2008)
I want to update modifieddate to today’s date when every there is a modification...
October 7, 2008 at 10:32 am
Okay, off topic but I need to ask. Where did you purchase your copy of SQL Server 2008 Developer Edition, and how long did it take for you to...
October 7, 2008 at 10:26 am
At this point, I'd like to to point you in another direction for a moment. Please take the time to read this article, http://www.sqlservercentral.com/articles/Best+Practices/61537/.
Follow the guidelines in it and...
October 7, 2008 at 10:18 am
Change this:
SET @DisplayNo = 'CNST'
SET @DisplayNo = '''%' + @DisplayNo + '%''';
SET @Desc = '''%' + @Desc + '%''';
SELECT @DisplayNo
to this:
SET @DisplayNo = 'CNST'
SET @DisplayNo = '%' + @DisplayNo +...
October 7, 2008 at 9:17 am
Jeff Moden (10/7/2008)
jcrawf02 (10/7/2008)
Or are we waiting for Porkslinger 😛 to give us another followup article?
Heh... what an idea... maybe I'll title it "Porkslinger: Have Chops, Will Travel." ...
October 7, 2008 at 9:03 am
Actually, I believe that indexes will help. I can't remember where I read it, but I believe that there has been improvements in the query engine in SQL Server...
October 7, 2008 at 8:59 am
I can see why this runs fast:
SELECT * FROM REFERRALS WHERE RECVD_DTTM >= '2008-10-06 23:59:59' AND RECVD_DTTM < '2008-10-05 00:00:00'
It is executing in 1 second where as
It won't select...
October 7, 2008 at 7:56 am
Viewing 15 posts - 24,136 through 24,150 (of 26,484 total)