T-SQL Tuesday #98 Round Up
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
587 reads
SQL Server Configurations – Back to Basics
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...
2018-01-11
12 reads
SQL Server Configurations – Back to Basics
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
536 reads
Fun with sp_rename
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...
2018-01-11
1,485 reads
How to Change the File Extension for a Data File
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions that we use for SQL Server data files are MDF (Primary Data File), NDF...
2018-01-11
9 reads
How to Change the File Extension for a Data File
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions for our SQL Data Files...
2018-01-11
398 reads
Changing the Path for the Master Database
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving...
2018-01-11
11 reads
Changing the Path for the Master Database
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a...
2018-01-11
356 reads
Fixing logins
I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...
2018-01-10
440 reads
Regular Expressions (Day 10)
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
458 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers