Viewing 15 posts - 1,906 through 1,920 (of 59,061 total)
That's one of the reasons why I want to see both the Backup and DBCC commands that are being used. We don't know what the OP is actually using.
February 11, 2023 at 5:02 pm
Heh... the previous post was SPAM about a "diet plan" that recommended ingesting cotton balls as part of the diet. I agree that's a bit ridiculous.
In that same vein, you...
February 11, 2023 at 4:52 pm
To start with, please post one of the actual backup commands that gets executed. Obfuscate the name of the database and any machine names the command may contain but don't...
February 11, 2023 at 3:59 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...
February 11, 2023 at 12:35 am
I think you can beat any splitting function by splitting in code with no need for aggregation.
As there are only a maximum of 4 values you can safely use...
February 10, 2023 at 9:41 pm
That's a good start.
When I was hot and heavy into doing a shedload of them for a whole bunch of different files, I wrote some T-SQL to read the first...
February 10, 2023 at 9:36 pm
https://ayende.com/blog/198945-B/on-ai-gpt-and-the-future-of-developers
Same problem in that article that many have. The author ends it with a conclusion of "My final conclusion is that this is a really awesome tool to...
February 10, 2023 at 9:16 pm
p.s. And I disagree... getting FORMAT files right isn't really a fright in my book.
February 10, 2023 at 8:07 pm
Where are the files located? Sounds like a strange question but you have a file path of 'C:\SQLData\WRsales\' for both the data and format files. Understand that file path is...
February 10, 2023 at 8:05 pm
When I wrote this reply https://www.sqlservercentral.com/forums/topic/sql-server-database-redunduncy#post-4148195 and pressed submit I got an error "Are you sure you want to do that?"
I could be missing the obvious but I'm not...
February 10, 2023 at 7:56 pm
I could see a huge potential on the sales side, being confidently incorrect is pretty much the only real requirement for a career in marketing 😛
BWAAA-HAAA-HAAA!!!. Now there's a...
February 10, 2023 at 7:50 pm
I don't know of a windows-driven "interrupt" that would do it (and, if someone does, please fire a flare 'cuz I'l love to know it!) but, if if there was...
February 10, 2023 at 5:01 pm
It's difficult to produce such a list of new functionality even when restricted to just those for T-SQL.
One of my OMG! favorite improvements was when the came out with STRING_AGG()...
February 10, 2023 at 4:43 pm
informaton schema was taking 0 cpu and 0 time.
Uh, huh... It did in my example, as well. You should also do more than one test to see why the...
February 10, 2023 at 4:32 pm
As emphatically strong a suggestion as I can make...
If you get the opportunity to take the all-day class on SQL Server 2022 put on by Bob Ward of Microsoft,...
February 10, 2023 at 4:26 pm
Viewing 15 posts - 1,906 through 1,920 (of 59,061 total)