Viewing 15 posts - 24,136 through 24,150 (of 26,486 total)
Learn something new every day on this site!
Keep up the good work, Steve!
😎
October 9, 2008 at 1:27 pm
Are you asking if you can restart the restore from the point of failure? No. You have to restart the restore from the beginning of the process.
(But then...
October 9, 2008 at 12:03 pm
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
Viewing 15 posts - 24,136 through 24,150 (of 26,486 total)