Happy Diwali………….
Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...
2012-11-13
744 reads
How to Use xp_dirtree to List All Files in a Folder
UPDATED -- Dec 31, 2012 -- Be sure to read Part 2 of this post discussing xp_dirtree.
Last week I blogged about how...
2012-11-13
71,816 reads
Mirrored Database as SSRS Data Source
Recently one of our report started to fail with error like Unable to Connect to Database error. Then only we...
2012-11-13
1,106 reads
Site Update – Performance Tuning
Here at gethynellis.com we offer a range of consulting services to help you manage and maintain your SQL Server environment,...
2012-11-13
585 reads
Happy Diwali
Wish you all a very happy and blessed festive season. May this festival of lights brings more brightness in your...
2012-11-13
695 reads
Migrating SQL Server Databases that use Database Master Keys
There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...
2012-11-26 (first published: 2012-11-13)
4,423 reads
TSQL Tuesday - What SQL Community Means To Me
Today is Tuesday, and its time for another edition of TSQL Tuesday #36, as we continue the eternal blog party...
2012-11-13
1,506 reads
T-SQL Tuesday #36 SQL Community
Community – What is it? Community is something that is improperly defined with words alone. Community is best defined through first person experience. Community is a feeling and a...
2012-11-13
10 reads
T-SQL Tuesday #36 SQL Community
Community – What is it?
Community is something that is improperly defined with words alone. Community is best defined through first person...
2012-11-13
867 reads
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,712 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers