Viewing 15 posts - 1 through 15 (of 1,883 total)
I vote for NULL. We really don't know that are the last 4 digits and unknown is NULL. We should not assume that the numbers will be 3333. As a...
September 30, 2021 at 4:16 pm
I guess you have to read that in English: ! is Not, < is Less, so !< is Not Less than
October 28, 2020 at 1:04 pm
3 alternative ways for your mind entertainment
August 27, 2020 at 1:20 pm
Great question, Steve!
I have tested a few things and theoretically your expression should have worked as it is a combination of the following 2 expressions that work
SELECT CAST(0x7e AS Int) ...
July 28, 2020 at 3:46 pm
Just tried that in Python, in Jupyter Notebooks
The output is 10.0
Also tried in Excel entering in the Formula bar
The cell contain the value of 10. Excel is a Microsoft product...
June 9, 2020 at 7:30 pm
Without minus signs the expression would evaluate to 10 as division and multiplication are equal in the order of execution. Plus and minus are to follow.
I do understand the explanation...
June 9, 2020 at 4:32 pm
Steve, wonderful question!
Funny story: Years ago when I created a ticket with a vendor of one of the industry leader CRMs that one view in the UI did not have...
May 22, 2020 at 5:45 pm
Shannonry, I don't have a BOL link, but in Management Studio do:
View - Registered Servers
Right-click on local server groups and select New Server Group, give it a name
Right-click on the...
July 25, 2019 at 9:24 pm
You can define a multi server query (registered servers) and run the query only once.
July 25, 2019 at 8:17 pm
The article is awesome!
This feature is like an online version of the linked server minus updates.
July 25, 2019 at 3:41 pm
September 27, 2016 at 9:09 am
Disk quotas can work! I like this idea.
I also read about File Screening, that can limit the file types that can be saved on disk. For example we can specify...
October 1, 2013 at 4:26 pm
I suggest another approach in SQL Server 2008.
Please try using Audits. They are under Security in SQL Serfver Management Studio. It takes just a few minutes to create. Then you...
October 1, 2013 at 12:08 pm
Check a few things;
- If your SQL Server is set up to audit failed logins, check SQL Server logs what was the error message. If not, run profiler to capture...
October 1, 2013 at 11:21 am
I don't know what the particular warnings come up for your package, you have to evaluate the warnings and determine if they are relevant or not.
My advice is to take...
October 1, 2013 at 11:05 am