Kent .Net/SqlServer User Group – Upcoming events
At the Kent user group we have two upcoming events. Both are to be held at F-Keys Training suite http://f-keys.co.uk/...
2011-06-05
645 reads
Blog Posts
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,771 reads
Using Nightly Populated Tables For Faster SQL Queries
A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality...
2011-06-05
1,295 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
579 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,289 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
993 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,815 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
914 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
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,008 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Bank BCA KCP Suari NO.TELPON 087781685647
WHATSAPP 087781685647 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121
BCA KCP Kas Karang Jati Tlpn/wa:085373737551
Komplek Ruko, Jl. Karang Jati Blok C 3 & 5, Karangjati, Kec. Bergas, Kabupaten...
BCA KCP Sultan Agung Tlpn/wa:085373737551
Jl. Sultan Agung No.115, Gajahmungkur, Kec. Gajahmungkur, Kota Semarang, Jawa Tengah 50232
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers