Full-Text Search – Stoplists in SQL Server
Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text...
2013-01-07 (first published: 2012-12-31)
6,570 reads
Wrapping Up 2012
Last year, I did a wrap up post of the year to see where I landed from where I wanted...
2012-12-31
1,638 reads
2012 in review !
Year 2012 was super special for me in many ways. Made lot of new friends, Attended SQLPASS Summit 2012 and had...
2012-12-31
1,350 reads
Replication in SQL Server
Replication is a way of distribution of database and their objects from one master database to one or more recipient databases...
2012-12-31
2,141 reads
Log Shipping in SQL Server
Log Shipping:- Log Shipping is a process of keeping the latest copy of the database of the primary database server...
2012-12-31
1,542 reads
Rebuild And Reorganization of Indexes
Rebuild and Reorganization of Indexes:- SQL Server has the ability of maintaining the indexes whenever we makes changes (update, Insert,...
2012-12-31
2,759 reads
Fragmentation in SQL Server
Fragmentation:- Fragmentation can be defined as condition where data is stored in a non continuous manner. In can be defined into...
2012-12-31
1,458 reads
Wrapping Up 2012
Looking back at 2012 I feel like I’ve written less than I planned to, and in some ways done less...
2012-12-31
1,470 reads
Phones, Tablets, and Even Windows 8
Last year I purchased two Kindle Fires for the family to use. The UI could be just a little bit/slow...
2012-12-31
1,544 reads
Last Weeks Top 10 “Reading” Links #13
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-31
1,735 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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