PASS 2009 Summit Site Open
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
594 reads
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
594 reads
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,857 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...
2009-03-24
950 reads
As I gain more experience I've found that stress comes in three forms; stress that is there that you don't...
2009-03-23
591 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard...
2009-03-22
754 reads
I was browsing the March 2009 issue of Visual Studio Magazine today and found that it's changing again. It's been...
2009-03-19
790 reads
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,656 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to...
2009-03-19
922 reads
I try to go to a spring training game once or twice a year and it serves as a useful...
2009-03-17
723 reads
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
2009-03-17
4,899 reads
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...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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