Basics of Indexes in SQL Server
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2012-09-29
1,286 reads
Parallel Execution in SSIS 2008 and later version
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now...
2012-09-29
986 reads
Reblog – September 21 to September 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-09-28
1,463 reads
Yet Another Facebook Page - Living For SQL Server
I have created facebook page named "Living For SQL Serever" couple of days back.
https://www.facebook.com/LivingForSqlServer
Inviting our community friends to like this...
2012-09-28
1,803 reads
Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,510 reads
I voted in the PASS Election - you should too!
If you are a member of PASS you have probably already received an email that looks like this:
--
From: <hq@sqlpass.org>
Date: Fri,...
2012-09-28
1,683 reads
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,753 reads
Time to Vote-PASS Board of Directors
It’s that time of year where we get to vote for the three best candidates to serve a two year...
2012-09-28
1,515 reads
SQL Saturday 151 Interview: Stacia Misner
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,724 reads
Full Text Search – CONTAINS
I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....
2012-09-27
4,829 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