Naked Conversations
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
369 reads
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
369 reads
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
302 reads
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,117 reads
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
304 reads
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
408 reads
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,744 reads
When I teach my introductory (and free) Successful Technical Speaking class to try to help beginners enter the world of speaking,...
2008-09-01
417 reads
It's Labor Day here in the US today, a holiday that is tribute to those of us that work, the journey to...
2008-08-31
1,782 reads
I was recently working with a student in a one on one format and one the scenarios he wanted to...
2008-08-28
1,438 reads
SQL Server makes it very easy for anyone to create a database. However it's worth spending a few minutes thinking about how you plan a database and SQL Server trainer Andy Warren brings us some thoughts on the subject.
2008-08-27
8,313 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