T-SQL Tuesday #029 – Useful Feature of SQL Server 2012
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,629 reads
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,629 reads
There are a few design choices that can make your SSIS packages run super fast when loading data from table...
2012-04-10
5,651 reads
All Quite on the Western Front
It is going to get noisy soon though! I”m speaking at SQLSaturday #111 in Atlanta...
2012-04-10
975 reads
I’m pleased to announce that this Wednesday April 11th 2012 Hilary Cotter will be presenting for the PASS DBA Virtual...
2012-04-10
1,515 reads
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,141 reads
Q. How can I obtain the members of a role within a database?
A. One method is to use sp_helprolemember
EXEC mydatabase.dbo.sp_helprolemember
--returns...
2012-04-10
974 reads
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,437 reads
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
838 reads
There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...
2012-04-09
3,304 reads
One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...
2012-04-09
2,845 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
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