Viewing 15 posts - 466 through 480 (of 1,995 total)
I get T-rex poo and SQL profiler (I know Grant is going to bite on this one - i'll put money on the next words out of his mouth are...
January 27, 2020 at 1:04 pm
so, to give some context - this is a consolidation of multiple servers (some 2014, some 2016) into a nice big server with "NO LINKED SERVERS" - it is however...
January 27, 2020 at 11:09 am
thanks for that
It's interesting in that article that there are new hint options and database specific settings, but not any opinion on whether they are good or bad.
I like the...
January 27, 2020 at 10:02 am
Yes, I am cranky. Because I am tired of being the guy with the shovel and broom who walks behind the horses in the parade.
wait - ???? you get...
January 27, 2020 at 8:45 am
in my searches - http://hilite.me/
not too bad
January 24, 2020 at 12:29 pm
curious on this one ---- has no-one ever come up with a CSS style for SQL code that is vaguely acceptable?
January 24, 2020 at 12:24 pm
If @EndStation is always greater than @BeginStation, then you can simplify like this. Note that I've also removed the NOTs and changed ANDs to ORs and >= to <...
January 24, 2020 at 12:17 pm
In today's meeting of the entire IT staff, we were discussing how interruptions prevent us from getting projects completed.
My boss, using me as an example, stated that I was...
January 24, 2020 at 9:01 am
They tell me the SQL server is slow and when I do a trace, the application is sending 100's of lines of bad SQL to the database. Half...
January 23, 2020 at 5:26 pm
MVDBA (Mike Vessey) wrote:i'm going to re-read the phoenix project (for about the 5th time) and seek wisdom. 🙂
I need to get the Unicorn Project and read it.
Santa clause bought me...
January 23, 2020 at 3:03 pm
which means either I screwed up on the 1st file import, or my files are not consistant…. which would be painfull
but that is a great spot
the col26 issue was because...
January 23, 2020 at 2:07 pm
but you are correct - dammit , now I want to buy a Pi and see what I can do
AND
on this note, SQL Server on Edge is now...
January 23, 2020 at 1:57 pm
That's not a shock really. But a little more sharing ahead of time, might, might, prevent some outages.
that would be a fantastic article... how we prevent outages..
I have a...
January 23, 2020 at 1:46 pm
same format - it's from AWS logging system, but we aren't exactly sure of the field lengths - some of them are quite long and we've had to set those...
January 23, 2020 at 12:04 pm
thanks Grant, now I can't CC anyone on an email without feeling guilty (and buying cakes for everyone.)
I used to be cranky, but now i'm the nice DBA who fixes...
January 23, 2020 at 9:17 am
Viewing 15 posts - 466 through 480 (of 1,995 total)