Partitioning in SQL Server - Part 3
Arshad Ali provides a step-by-step guide to create a partitioned table/index.
SQL Intersection in Las Vegas This Spring
Come join Steve Jones, Grant Fritchey and an amazing lineup of speakers at the spring SQL Intersection conference in Las Vegas, April 8-11, 2013. Register now and you get a Surface RT tablet.
DBA Hypochondria
It is easy to become overwhelmed by server symptoms (aka metrics), in the forlorn hope that the more we collect, the clearer a picture we'll assemble of what ails the server. We should, of course, be looking at the whole patient.
Using the Data Profiling SQL Server Integration Services SSIS task
Have you ever had to write a bunch of TSQL to do some data analysis on the table data in your database. If you have you'll know that this can become a fairly time consuming and tedious task? SQL Server 2012 Integration Services has a feature called the Data Profiling task that can help you perform this analysis much easier and faster (this feature is also available in SQL Server 2008). This task can help you find potential issues with your existing data as well as help you become more familiar with the data in a database that you have just started managing.
Baselines
It can be hard to analyze performance without a baseline. This week, Steve Jones asks how you might use your baseline to better determine what problems you are having with your SQL Server.
Join Operations – Nested Loops
This is part I of III in a series on the physical join operators in SQL Server.
Silent Truncation of SQL Server Data Inserts
There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.
A New Type of Colocation Facility
Microsoft is working on their generation 4 data centers, which might be a great idea for companies if they can implement a private cloud.
Custom Metric - Indexes with Excessive Writes
A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables.
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Alamat BCA KCP Percetakan Negara Telp:08218520153
WhatsApp CS 628218520153 Jl. Percetakan Negara No.223 C, RT.3/RW.5, Rawasari, Kec. Cemp. Putih, Kota...
Alamat BCA KCP Gondangdia Lama Telp:08218520153
WhatsApp CS 628218520153 Jl. RP. Soeroso No.25, RT.9/RW.5, Cikini, Kec. Menteng, Kota Jakarta Pusat,...
Alamat Kantor BCA KCP Alaydrus Telp:08218520153
WhatsApp CS 628218520153 Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers