Should Code Camp/SQLSaturday Be Free?
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend...
2008-02-13
642 reads
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend...
2008-02-13
642 reads
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
2008-02-12
13,052 reads
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
451 reads
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
2008-02-12 (first published: 2007-02-27)
25,484 reads
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
991 reads
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
352 reads
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
810 reads
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
520 reads
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past...
2008-02-11
567 reads
Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.
2008-02-07
3,757 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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