Office 2010 and Windows XP (64 bit)
I wanted to install Microsoft Office 2010 on an old Windows XP (64 bit) laptop. I tried running the setup...
2012-09-18
1,634 reads
I wanted to install Microsoft Office 2010 on an old Windows XP (64 bit) laptop. I tried running the setup...
2012-09-18
1,634 reads
Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...
2012-09-17
4,994 reads
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create...
2012-09-19 (first published: 2012-09-17)
3,341 reads
If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip,...
2012-09-17
751 reads
My current client has a five story building, two break rooms and two sets of bathroom per floor, with I’m...
2012-09-17
635 reads
SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.
Option...
2012-09-17
979 reads
This last Saturday (09/15/2012) I traveled to St. Louis to present at #sqlsat154. My colleague David Klee (blog/@kleegeek) and I...
2012-09-17
900 reads
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,183 reads
I will be delivering Learning Tree course 137 SQL Server 2008 a Comprehensive Hands-On Introduction in London this December (18th...
2012-09-17
755 reads
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,917 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. 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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers