Viewing 15 posts - 6,241 through 6,255 (of 59,070 total)
For those complaining about review boards... despite the pain they seem to bring, I found that such "heavy handed" review boards are a thousand times better than having a "cowboy"...
October 9, 2020 at 1:18 pm
From the Article:
...Microsoft does, as do lots of organizations trying to embrace DevOps and produce higher quality...
Ok... you caused me to blow a pork chop bone out of my...
October 9, 2020 at 2:34 am
And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No...
October 8, 2020 at 7:57 pm
Hi,
We have a database that has 50GB of data, 99% of which is in one table. In this table there are 31,004,447 records, the developer is running a query...
October 8, 2020 at 4:46 pm
If the format is guaranteed an you only want the first element, then the code can be greatly simplified.
SELECT Result = SUBSTRING(SomeText,4,CHARINDEX('&',SomeText,4)-4)
FROM #Stuff
... October 7, 2020 at 6:04 pm
Thanks guys! We noticed this issue again. So this time I did not restart the database server at all and instead advised to restart application servers only and everything...
October 7, 2020 at 4:45 pm
How about query time-out to exit the query when it has been executed over default 10 minutes to unlimited 0?
If you have a front end query that's taking longer...
October 7, 2020 at 4:37 pm
Are you sure your data system really needs it all in actual columns? ( advocate of the devil, I know )
Have you considered putting those "free wheeling columns" into...
October 7, 2020 at 3:54 pm
Even though I'm a fan of SQL Profiler, I don't use it to find queries that may be an issue. I've also found that "long running queries" are not usually...
October 7, 2020 at 1:32 pm
... but take everything it recommends with a grain of salt the size of a Buick.
BWAAAA-HAAAA-HAAAAA!!!! Man, am I ever glad I didn't have a mouthful of coffee when...
October 6, 2020 at 5:33 pm
Using NOLOCK is the SQL version of Russian Roulette.
Heh... with 5 of 6 chambers loaded and the really bad part is that you won't know that your report has...
October 6, 2020 at 5:11 pm
October 6, 2020 at 3:45 pm
I have been reading that DBAs are going to go away as well. The first time that I read that was probably 20 years ago.
Don't worry about the career...
October 6, 2020 at 3:40 pm
Ok, try these out with the data you posted above. The "IsCyclic" column should be a big help for you. Like you said, the first one does a whole lot...
October 6, 2020 at 4:22 am
Not sure what the question is. If these files are saved from the end user, and they probably will be, then if they receive more than 1 day, they...
October 6, 2020 at 1:38 am
Viewing 15 posts - 6,241 through 6,255 (of 59,070 total)