Double-Dash Comments, the Hidden Menace
While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a...
2012-03-12
2,467 reads
Blog Posts
Factors that can delay Log Truncation – LOG BACKUP
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs...
2012-03-12
1,262 reads
Jedi Mind Tricks
Here’s a story from a recent meeting. We were discussing some problems and the team was talking through some options...
2012-03-12
790 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,198 reads
MDX Functions: BottomCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
1,413 reads
MDX Functions: TopCount
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
2,236 reads
Monday Morning Mistakes: Not Setting Memory Limits
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,436 reads
SQL Server 2012 RTM–Are you waiting for SP1?
As you probably know by now SQL Server 2012 was launched last week, Microsoft had an online launch event that...
2012-03-12
3,473 reads
Configure Windows Server 8 ISCSI Target
In part 4 will configure Windows Server 8 ISCSI Target to complete SQL Server 2012 Next Gen HADR labs prequisites,...
2012-03-11
1,980 reads
2012-03-11
4 reads
Blogs
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
is the ssrs auto refresh without its faults
Hi, i considered power bi with embedded for this. Not a big fan...
Random Execute SQL Task(s) keeps hanging when I try to run it in parallel
Hi everyone I am trying to implement parallelism in my SSIS package. There are...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers