Great Tools for Formatting T-SQL
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-10
1,219 reads
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-10
1,219 reads
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-10
768 reads
Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...
2012-12-10
1,058 reads
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,345 reads
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
839 reads
I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done...
2012-12-09
810 reads
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
740 reads
When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...
2012-12-08
1,767 reads
Sending
Querying Data on Mail:
Sometimes we need to send data fetched from query on
mail automatically. You can
create report and after running...
2012-12-07
759 reads
Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value...
2012-12-07
3,871 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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