Transact-SQL query to obtain basic information about partitioned tables
Here is the simple query that returns basic information about all tables in a database that are partitioned:
SELECT SCHEMA_NAME([schema_id]) AS...
2014-02-17
1,617 reads
Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution
You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...
2014-02-17
1,074 reads
First Presentation Ever And My 50th Post
Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...
2014-02-17
669 reads
The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,558 reads
Million Dollar Buggy Club The baddest swamp buggies in the south! #4×4
The baddest swamp buggies in the south!
Formed in 2009 the Million Dollar Buggy club was originally comprised of 10 members...
2014-02-16
662 reads
Deploying a Hadoop Cluster on Amazon EC2 with HDP2 #bigdata #hadoop
In this post, we’ll walk through the process of deploying an Apache Hadoop 2 cluster on the EC2 cloud service...
2014-02-16
1,683 reads
SQL Saturday #285 Atlanta
It’s been a couple of months since my last SQLSaturday and it’s time! Atlanta is my third SQL Saturday that I’ll...
2014-02-15
239 reads
SQL Saturday #285 Atlanta
It’s been a couple of months since my last SQLSaturday and it’s time! Atlanta is my third SQL Saturday that I’ll...
2014-02-15
501 reads
I’m on Twitter! @AdamKreul
I’m just a little late to the party, but no time like the present, right? I plan to be very...
2014-02-15
641 reads
Comparing Columns In Power Query
A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a...
2014-02-15
774 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Question of the Day
Switching Schemas 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 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