Viewing 15 posts - 196 through 210 (of 1,999 total)
I cant see anything obvious but i'm looking at result sperator as my first guess
February 28, 2020 at 10:51 am
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In...
February 28, 2020 at 10:29 am
Now i'm interested in your reading interests. If I were a betting man I'd go with Ian M banks
February 28, 2020 at 9:40 am
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my experience...
February 28, 2020 at 9:32 am
these are super cool examples
I used to use C# and the Redgate SDK for things like this (such as checking if all 100 servers had the same database structure for...
February 28, 2020 at 9:25 am
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my experience it's a...
February 27, 2020 at 4:57 pm
One idea:
Add every server to a group in Registered Servers in SSMS. Then, open a query from that qroup which will open the query connected to every instance.
You can...
February 27, 2020 at 4:28 pm
just thinking outside the box
Because you have no key then replication is out of the game
could you move the tables you need to a new filegroup? that gives you lots...
February 27, 2020 at 4:05 pm
Grant nailed it there - do your checkdb on a different server.
you can even include it in the restore process, then you get a restore test and a checkdb all...
February 27, 2020 at 3:32 pm
If I get a chance to, I'll happily be the first one to make it work in production. Same as I got Memory Usage of Memory Optimized Tables under...
February 27, 2020 at 3:18 pm
it's a little bit like prevention vs abortion.. triggers will abort the process after the fact. a unique index or pk will kill it before it starts
you can use some...
February 27, 2020 at 9:25 am
its ok
we've all done it.... mostly when i'm hungover 🙂 accidental deletes occur. 🙂
February 27, 2020 at 9:09 am
I don't know about the last month, the jury is still out, but last night was pretty good.
We were watching the Justice League movie. Myself, and my 10, 7,...
February 27, 2020 at 9:04 am
I still look at Memory-Optimized TempDB Tables with jealousy. I wish SQL Server 2019 was out there just a few months earlier and I would've argued for 2019...
February 27, 2020 at 8:41 am
I always just ask management if they'd eat a 2 year old egg. 😀
man , i'm stealing that quote
February 27, 2020 at 8:38 am
Viewing 15 posts - 196 through 210 (of 1,999 total)