SpeedPASS Printing
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
239 reads
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
239 reads
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
2019-08-27 (first published: 2015-06-05)
639 reads
I mentioned in earlier posts that I’m using Trello this year for managing SQLSaturday tasks and figured I might as well go all in and add some of the...
2019-07-26 (first published: 2019-07-09)
306 reads
2019-07-26 (first published: 2015-08-28)
594 reads
For those who haven’t used the admin tools for SQLSaturday when an event is created there are a set of messages loaded automatically. It’s up the event admin if...
2019-07-12 (first published: 2019-06-15)
298 reads
One of the interesting but not often used features of the SQLSaturday tools is the announcement/news (in the admin tools, its Message Center | Announce News) to do mini-blog...
2019-07-05 (first published: 2019-06-15)
167 reads
I’m trying Trello this year to manage both SQLSaturday and our other events. Part of that is giving the whole team visibility of the work that remains to be...
2019-06-18
86 reads
Misc notes: Jax. Ice cream break in the afternoon is nice, but the waffle cones on site make all the difference, the smell is hard to miss! Jax. Rooms...
2019-06-14
29 reads
We’ll be event number 911, set for September 28th at our usual location at Seminole State College. Maybe something interesting to do there as far as a theme. Call...
2019-06-14
60 reads
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
2019-05-31 (first published: 2015-03-25)
316 reads
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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