October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and...
2014-10-08
631 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,301 reads
Fill Factor vs Page Splits – Measure It..!!
I have been trying to solve the puzzle of “How to evaluate my current Fill Factor setting?”, and there have...
2014-10-08
1,339 reads
Invite for #TSQL2sday #59 – My Hero!
It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday,...
2014-10-13 (first published: 2014-10-08)
5,215 reads
Non-obvious APS/PDW benefits
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,075 reads
Beware the defaults! (in windowing functions)
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,642 reads
The full text error and why I was happy to see it.
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,131 reads
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
846 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
714 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
12 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers