Viewing 15 posts - 1 through 15 (of 3,537 total)
DAMMIT!! I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!
Does anyone still follow this thread, and if so, can...
August 30, 2023 at 10:51 pm
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
I wouldn’t. I know better. 😜
August 15, 2023 at 6:47 pm
Knowing your feelings on so called SQL Server best practices, Jeff, would you trust a tool like this if it existed 😏
June 17, 2023 at 10:42 am
Oops I think I did the same ☹️
June 17, 2023 at 10:37 am
If you ever had to deal with Assembler then COBOL would look like the futuristic flying car. When I was in college they taught us both Assembler and COBOL. ...
May 31, 2023 at 3:31 pm
Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean...
May 28, 2023 at 5:36 pm
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual...
May 9, 2023 at 7:19 pm
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets ((but...
May 9, 2023 at 7:07 pm
Why is it acceptable that a test environment is less secure than a production environment?
It's not, IMHO, and I don't see anywhere in the thread above where that...
April 12, 2023 at 12:28 am
Step 1... find everything in the database that will get you fired when someone steals them from your test environment and obfuscate them. You really don't want to read...
April 11, 2023 at 12:01 am
It’s been a while since I last did sql admin. SQL server configuration manager will tell you what account it is using. If it is a domain account ie AD, make...
February 22, 2023 at 9:57 pm
They way he/she is doing it, it doesn't need to be unique. It only needs to reduce the number of records that need to be scanned at low cost.
This...
February 22, 2023 at 9:03 pm
Full text indexes are an option. Although, in all honesty, I hate 'em. Hard to maintain and frequently don't actually speed things up much, if at all. Extra storage....
February 22, 2023 at 8:41 pm
I wrote some T-SQL to read the first row (which contained the column names) and had it create a CREATE TABLE statement from that header and the BCP Format...
February 10, 2023 at 10:25 pm
I think most folks would say your confused, David. They rather think I should be IN an institution. 😀 😀 😀
LOL. Maybe we could be in the same room...
February 8, 2023 at 1:57 am
Viewing 15 posts - 1 through 15 (of 3,537 total)