Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
16 reads
Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,282 reads
SQL Server Professionals: NYC Summer Spectacular! Training & Events
This is a very exciting summer to be in New York City! We’re not just talking Central Park, the Theatre...
2012-06-04
1,622 reads
“Green” Database Administration
For the past few years, I have seen tens of sql server boxes added in my work environment every year,...
2012-06-04
4,640 reads
Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,255 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
238 reads
Max Server Memory
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,216 reads
Investment for DBA Career
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,076 reads
SQL Server 2008 Security Best Practices
If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...
2012-06-01
13,348 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
911 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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