Viewing 15 posts - 48,211 through 48,225 (of 59,064 total)
Heh... absolutely... we need a copy of the file, a copy of the record layout, and copy of the CREATE statement for the target table, and any gotcha's that you...
September 18, 2008 at 9:39 pm
karthikeyan (9/18/2008)
For what YOU did, yes. But you moved lines of code I posted out of order. You have to figure out where the Pipe character is first...
September 18, 2008 at 9:29 pm
In that vein, I normally make the test boxes less robust than the production server. If it's fast on the test box, imagine what it will do on the...
September 18, 2008 at 9:10 pm
Steve Jones - Editor (9/18/2008)
I'd rename the table. That will tell you if it's still being used.Quick.
Heh... that's my favorite method. But, I believe the OP might have a...
September 18, 2008 at 9:07 pm
bkDBA (9/18/2008)
Jeff Moden (9/18/2008)
Ummm... that'll find the last date a table was SELECTED from?
Yes, provided the new 2008 database audit events are set up:
2008 BOL says: "SQL Server audits consist...
September 18, 2008 at 9:05 pm
Problem:
SELECT 1/10
Solution:
SELECT 1/10.0
September 18, 2008 at 2:37 pm
dva2007 (9/18/2008)
You are creating a table or declaring a table? there is no syntax which you are using. Please use create table syntax.
Ever heard of "Table variables"?
September 18, 2008 at 2:34 pm
PaulB (9/18/2008)
abba (9/18/2008)
Syntax will probably be the least of your concerns.:w00t: I respectfully disagree 🙂
I'll agree with that disagreement... syntax changes will be a doozy. Wait until...
September 18, 2008 at 2:31 pm
Jason Wisdom (9/18/2008)
TempDB is so much more important in SQL 2005 than it was in earlier versions.
And the default settings of 8MB / 1MB with 10% growth is...
September 18, 2008 at 2:26 pm
Ummm... that'll find the last date a table was SELECTED from?
September 18, 2008 at 2:20 pm
If the data is on a SAN, the SAN comes with software to make it easy to do this. Once it's setup (read the documentation that came with the...
September 18, 2008 at 2:15 pm
Without a bit more info about the table and the reason for the update, best I can say is...
SET ROWCOUNT 100000
SELECT 1
WHILE @@ROWCOUNT > 0
BEGIN
.... do your update
END
SET ROWCOUNT 0
September 18, 2008 at 2:11 pm
Matt Miller (9/18/2008)
Jeff Moden (9/17/2008)
Mark (9/17/2008)
DECLARE @S VARCHAR(30)SET @S='99202 10060 99000 A6402'
SELECT LEN(@S)-LEN(REPLACE(@S,' ','')) AS NumberOfSpaces
THAT's the way to do it... no RBAR, no join! 🙂
Except...It will return the wrong...
September 18, 2008 at 1:12 pm
Viewing 15 posts - 48,211 through 48,225 (of 59,064 total)