Comparing Inline and Multi-Statement Table-Valued Functions
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,845 reads
Blog Posts
Dynamic Add/Remove file in Mirroring/Logshipping
Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...
2012-02-15
477 reads
Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”
Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will...
2012-02-15
1,664 reads
Meme 15 - LinkedIn
The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn. I felt...
2012-02-15
389 reads
PASS Data Arch VC presents Steve Simon - On Beyond Zebra AdventureWorks OR Where Did I Go Wrong?
I meet Steve when he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...
2012-02-15
731 reads
SQL Server – DBA productivity and less is more
A typical DBA day can include a mixture of Operational, Engineering and Architectural tasks. Whilst maintaining 100% database server availability...
2012-02-15
692 reads
SQL Server 2012 (“Denali”): Contained Databases
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure,...
2012-02-15 (first published: 2012-02-13)
2,914 reads
SQL Server 2012 (“Denali”): T-SQL Enhancements
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with...
2012-02-15
5,146 reads
SQLRockstar's SQL Someday
http://vimeo.com/33411604
This is a talk given by Thomas LaRock (@SQLRockstar to you Twitter-folk) at an event last fall in NYC called...
2012-02-15
374 reads
USB/Flash Drive Security
Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...
2012-02-15 (first published: 2012-02-13)
2,210 reads
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
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...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
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