SQL Server Data Tools (SSDT) – January 2014 update
The SSDT January 2014 release has been updated to support both SQL Server 2012 Parallel Data Warehouse Appliance Update 1...
2014-01-28
1,488 reads
Movie Adaptations of Books
I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both....
2014-01-28
811 reads
Virtualization resource consumption counters lie to you
OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics...
2014-02-06 (first published: 2014-01-28)
2,154 reads
Know When it’s Good Enough
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love...
2014-01-28
719 reads
Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks
Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and...
2014-01-28
1,137 reads
If You’re Not Doing Anything….
Hey… Pssst… Yeah, you there on the couch. Listen, if you’re not doing anything around lunchtime on February 6th, I...
2014-01-28
641 reads
Inside the Statistics Histogram & Density Vector
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-04 (first published: 2014-01-28)
4,192 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,262 reads
Powershell in a Month Day 13 – Remote Control
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-27
1,058 reads
Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance
We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....
2014-01-27
1,885 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