Viewing 15 posts - 571 through 585 (of 2,356 total)
Without an order by, are you sure you are getting the proper value? This looks like a bug waiting to happen.
Can more than one of the 5 selects return a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 19, 2022 at 6:21 am
When an identity column is created on a published table, look at the generated code. It will include the NOT FOR REPLICATION clause.
You do not want the column to be...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 19, 2022 at 6:17 am
Also, free space is not a bad thing.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 13, 2022 at 5:07 pm
This may be a bit off topic, but what information do these tools provide to you that makes them worth the cost? I've owned (inherited mostly) various monitoring tools over...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 13, 2022 at 5:02 pm
Lordy... CodeProject just published a very interesting AI incident. Here's the link they published. Pretty spooky and seriously concerning stuff, IMHO. Watch your kids, folks.
Yeah, if you read about...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 30, 2021 at 1:47 am
Got an email from Degreed.com giving me recommendations for virtual training and … well, apparently there are urgent SQL courses I need to take today and ...
Well, what do...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 30, 2021 at 12:10 am
This is the best line, I'll make sure I skip over any of your questions. Glad you got it 'resolved'
Doing it with create scripts and DDL and all the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 29, 2021 at 3:19 pm
Making some assumptions based upon experience, I'm guessing that the first query using like '%string%' is the original code that's been in place for a long time?
If so, have you...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 10:37 pm
No, just no. This sounds like a bad idea.
Curious, what datatype has exceeded the values?
We have a logging table that does this every few years, but because we keep the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 10:26 pm
For the best practices who should be installing SQL Patches? I see in most of the organization it is installed by Windows team using SCCM and DBAs have no...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 10:14 pm
aw... am I not following the rules? WTF man!
Doing it with create scripts and DDL and all the bullshit you want would take way too much time! I'm NOT...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 9:59 pm
Re-boot your computer. That is a local resource issue
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 9:51 pm
You can write a stored procedure to check the money limit, then set up SQL Mail and use sp_send_dbmail to generate the email based on the limit.
Then use a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 28, 2021 at 9:48 pm
My favorite lie is that NOLOCK improves performance.
Of course it must vs taking locks.
"and use snapshot isolation." MEGA-HUGE overhead. SI should only...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 22, 2021 at 7:39 pm
My favorite lie is that NOLOCK improves performance.
Of course it must vs taking locks.
"and use snapshot isolation." MEGA-HUGE overhead. SI should only be used when truly...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 22, 2021 at 5:08 pm
Viewing 15 posts - 571 through 585 (of 2,356 total)