Retrieve unsaved query
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...
2013-03-20
135 reads
Blog Posts
Retrieving the next or previous element node value in an Xml blob using XQuery
It’s been a little while since I wrote a blog post on my favourite subject but this is from a...
2013-03-20 (first published: 2013-03-13)
5,330 reads
Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,462 reads
Benefits of using views in a BI solution
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
745 reads
Cumulative Updates - SQL Server 2012 SP1 CU3
As part of theirIncremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #3.http://support.microsoft.com/kb/2812412
This CU contains 38 fixes and is pertinent for versions 11.0.3000...
2013-03-19
21 reads
Do You Know sys.dm_exec_text_query_plan?
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,818 reads
Remove duplicate records from a table in SQL server
Here I create a table and
inserted some duplicate records for testing purpose.
createtable temp(cust_id varchar(50))insertinto temp(cust_id)values('oms1'),('oms2'),('oms1'),('oms2'),('oms3')select*from temp
Method 1: (You can simply...
2013-03-19
3,849 reads
Speaking Tomorrow Night at MagicPASS
I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics...
2013-03-19
656 reads
SQL Lunch – Power View Against Multidimensional Models
It has been some time since I have hosted or presented on the SQL Lunch. Work and home life is...
2013-03-19
1,332 reads
SQL Server 2000 Extended Support ending soon………21 days left
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will...
2013-03-19
1,038 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Soreang +62 838-4945-0961
Wa:083849450961 No. 1-A, Jl. Raya Soreang, Pamekaran, Kec. Soreang, Kabupaten Bandung, Jawa Barat 40912
Alamat Telp BCA KCP Indramayu +62 838-4945-0961
Wa:083849450961 Jl. Di Panjaitan No.69, Karanganyar, Kec. Indramayu, Kabupaten Indramayu, Jawa Barat 45212
Training the next generation
Comments posted to this topic are about the item Training the next generation
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers