Forum Replies Created
Viewing 15 posts - 36,961 through 36,975 (of 39,717 total)
-
RE: Comparing varchar datatypes with values like x.x.x
Antares has the best solution.
Steve Jones
-
RE: Need to force proper case of sentence
Of every word? If the first word, use substring and upper() and lower()
select upper(substring(col,1,1)) + substring( col,2)
Steve Jones
-
RE: Is T-SQL enough to be a valuable Yukon DBA?
I think it will be enough. Nice to know the others, but not necessily needed. Last I saw, Yukon wasn't completely set, so not sure how much .NET will be...
-
RE: Read from Text File Into Table?
DTS can do this. Bulk Copy can, but you'd probably want to do a DOS find and get the lines you need into a separate table.
Or load hte whole thing...
-
RE: Lost SQL Server Registration during pass change
Running XP Pro, using Domain (AD Native mode) and no issues changing passwords. Do it every 30 days (4 so far).
Steve Jones
-
RE: Archiving Data.
I'd agree. Depends if you need it. You could also denormalize and include some of the FK stuff into the table.
Steve Jones
-
RE: Forum Search
no, it's a bug. I've seen it disappear on some pages. Always on the home page though.
Steve Jones
-
RE: Truth about Oracle and MSSQL...Help needed
I'm an MS user and have been working with SQL Server for 12 years. I've only developer (briefly) against Oracle, and that was 7, so I'll admit first off that...
-
RE: Change Screen Colors
That's a bug with the forum that only occurs some of the time. We use the Snitz forums (forum.snitz.com) and are testing their upgrade as well as another forum. We...
-
RE: Forum Search
The Search button on the top menu will search articles and / or forums.
We know we need to enahance this, just haven't had time.
Sorry.Steve Jones
-
RE: Sql Mail Error
Check and see if something may have changed on the Exchange server.
Steve Jones
-
RE: Table size
Thanks for the update.
Steve Jones
-
RE: Bright Stor backup solution
The general consensus from most experienced DBAs appears to be use disk backups with the native SQL solution and then go from there to tape. Not thrilled with the tape...
-
RE: Table size
Have you checked fragementation? Could be using more extents.
Steve Jones
-
RE: duplicate dbo tables
This is allowed, most likely someone logged in as "scheme" and created the table and someone also created the table as "dbo".
You would have to check your application or use...
Sorry.Viewing 15 posts - 36,961 through 36,975 (of 39,717 total)