May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
468 reads
Blog Posts
Minutes of the April 2010 PASS Board Meeting Published
This was a phone meeting on April 8th, 2010, that covered:
Possibility of an online track at the 2010 PASS SummitDiscussion...
2010-05-11
690 reads
Minutes of the February 2010 Board Meeting Posted
Strangely we’ve had the March minutes up for many weeks, but just now getting the February minutes posted. This was...
2010-05-11
601 reads
Notes from the May 6th, 2010 oPASS Meeting
We moved to Thursday this month to line things up so that Dean Richards from Confio could do a presentation...
2010-05-11
548 reads
Put your left LOB in, put your left LOB out…
It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more...
2010-05-11
1,915 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
773 reads
Simple Production Script Auditing Best Practices: Including Query in the Result Set
To make it easier for others to audit the results of a script you have run on current production servers,...
2010-05-11
1,486 reads
Some New DMV Queries for SQL Server 2008 R2
I was spelunking around in SQL Server 2008 R2 today, after looking at a PowerPoint presentation by Madhan Arumugam about...
2010-05-11
1,784 reads
SQL Server with MS Access .adp Project file
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,859 reads
STS-132 NASA Tweetup or "I've Won A Golden Ticket!"
Note: This is a very non-SQL Server related post. If you don't want to read something personal about me feel...
2010-05-11
852 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Panglima Polim Raya Telpon/WA:08137887595
BCA KCP Panglima Polim Raya Telpon/WA:08137887595.Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1,...
BCA KCP Pluit Raya Tlpn/Wa 0853.7373.7551
Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14440
BCA KCP Sejati Mulia Telpon/WA:08137887595
BCA KCP Sejati Mulia Telpon/WA:08137887595.Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, Jati Padang,...
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