Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
902 reads
Blog Posts
SQL Server - BACKUP LOG WITH NO_LOG
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.
There is no replacement for this...
2012-01-22
2,602 reads
SQL Server- Output clause
Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...
2012-01-22
2,171 reads
SQL server the timeout period elapsed prior to completion of the operation
AdvertisementsSQL server clustering the timeout period elapsed prior to completion of the operation
Recently I faced one of our application could...
2012-01-22
16,159 reads
SQL Server – Modifying Production Data Good Practise
Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...
2012-01-21
992 reads
Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,133 reads
DBAs and the Career-Life Balance
Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...
2012-01-20
875 reads
Local Community Events & User Groups from Around Town....
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,558 reads
Nooner Viewing Summary
Over the last few weeks, I’ve been watching SQL Server videos and webcasts. My primary motivator in doing this is...
2012-01-20
587 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
886 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
I Need a CS Degree. I Don't Need a CS Degree
Comments posted to this topic are about the item I Need a CS Degree....
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers