Tools
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,185 reads
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,185 reads
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,374 reads
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
474 reads
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,017 reads
One of the things I use to identify how well a company is managed is by looking at how (well)...
2008-07-13
1,630 reads
My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately...
2008-07-13
1,413 reads
SQLSaturday #5 in Olympia is progressing nicely. Greg, Russ, and team have locked in a venue and with registration just...
2008-07-11
421 reads
I did quite a bit of reading during a recent week off including two biographies. One was Boyd: The Fighter...
2008-07-10
403 reads
A couple weeks back I posted Employee or 1099 and now that my friend Wes Dumey has posted his last installment, I...
2008-07-09
326 reads
Ran across IronKey Personal in PC Magazine and thought some of you might be interested. It has built in encryption,...
2008-07-08
289 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