Static or “global” variables in T-SQL using CLR UDT
I faced problem that I had many lookup tables like ProductType, ClientType etc. and wanted to refer to their values...
2011-06-05
1,780 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
580 reads
Maximum recursion possible with CTE in SQL Server 2005/2008
In my last blog about Tally Tables, we talked about the use of
recursive CTEs to generate Tally Tables. Following that,...
2011-06-04
20,296 reads
What is SSMS Addin
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
712 reads
PerformancePoint 2010 source control
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
917 reads
Re-blog – May 27-June 2
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-03
499 reads
Use PowerShell to Add a Login to a Database Role in all Databases
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
6,195 reads
SQLSaturday #77 Pensacola Florida Event Preview
Sometimes, even if I’m not attending, some SQLSaturdays stand out to me, and catch my interest. I guess it’s a...
2011-06-03
1,010 reads
Analysis Services Operations Guide Released
The Analysis Services team has been working overtime lately to provide added community support for the traditional UDM-based OLAP engine...
2011-06-03
997 reads
Avoiding OR Conditions with Joins
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...
2011-06-03
2,833 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
Alamat Kantor BCA KCU Cianjur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Alamat Kantor BCA KCU Depok Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers