MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
990 reads
is count(1) faster than count(*)?
Recently I saw a post regarding the count(1) and count(*)
http://www.sqlservercentral.com/articles/T-SQL/102474/
the post said "You know that doing COUNT(*) on a table with...
2013-10-28 (first published: 2013-10-20)
5,814 reads
Summit 2013 Review!!! plus SQLSaturday #237 Charlotte BI Edition
The week is over and I waiting for my flight home. I did not to get to as many sessions...
2013-10-20
970 reads
PASS Summit Report #16 (Mentoring)
A couple years back Steve Jones and I started The Mentoring Experiment. Our first experiments to see how effective non-local...
2013-10-19
891 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
423 reads
PASS Summit 2013-Blogger Interview With PASS Officers
On Thursday the PASS bloggers were given the chance to meet with the PASS officers and I participated along with...
2013-10-19
694 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
443 reads
Cumulative SUM in SQL Server
Sometimes we need to find sum of first and next row in cumulative way.
Create table and insert data:
CREATE TABLE [dbo].[testsum](
...
2013-10-25 (first published: 2013-10-19)
41,482 reads
PASS Summit 2013 Report #15
Slower day today, fewer notes!
Most of my morning spent on mentoring and some networkingLunch today was Birds of a Feather,...
2013-10-18
668 reads
PASS Summit 2013–Board Q&A
PASS Board Q&A just starting. Session is being recorded – transcript will be published, no decision on whether recording will be...
2013-10-18
719 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers