Umfrage: Welche Tracing und Analyse-Tools verwendet ihr für SQL Server?
(DE)In meiner Session „Hasta la vista Profiler – Tracing with Extended Events“, die ich nun seit über einem Jahr bei...
2013-06-20
2 reads
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
801 reads
The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...
2013-06-20
2,419 reads
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,806 reads
There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...
2013-06-19
55 reads
Yet again I've seen an audit request where the auditor wants the DBA to show what SQL Server's settings are...
2013-06-19
8,267 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-19
916 reads
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
522 reads
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,796 reads
I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...
2013-06-19
1,343 reads
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...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
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