SQL Street
I’m involved with with a new venture called sqlstreet.co.uk. SQL Street is the place to shop for database experts.
Here’s a...
2012-11-05
747 reads
I’m involved with with a new venture called sqlstreet.co.uk. SQL Street is the place to shop for database experts.
Here’s a...
2012-11-05
747 reads
I’m making the slides available from my SQL in the City 2012 talks. You can download them here
Prepare for...
2012-11-05
1,279 reads
Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics...
2012-11-05
1,939 reads
Morning
Could not sleep past 4:30AM this morning, daylight savings time and 2 time zone changes did not help. So, exercise...
2012-11-05
685 reads
When it comes to attacking SQL Server, whether we're talking about the security of an installation or as a piece...
2012-11-05
1,473 reads
I like reading and while I read more on an e-reader than I used to, I still prefer the printed...
2012-11-05
849 reads
I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions....
2012-11-04
648 reads
Three days to go. I need to get my schedule sorted out, how about you. What influences your schedule? Since...
2012-11-03
562 reads
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...
2012-11-03
1,182 reads
Looks like I’m not the only one enjoying Friday.
Some of the staff at Red Gate had a Hawaiian day. Nice...
2012-11-02
1,050 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