Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,342 reads
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
542 reads
Using multiple CTEs in one query
This is a fairly simple thing to do, but I had to look it up the other day and thought...
2014-01-22
1,407 reads
Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
518 reads
Volunteers Needed For PASS SUMMIT
Last night I submitted my application to volunteer for the 2014 PASS Summit Program Committee.
Not know what PASS is? head...
2014-01-22
1,196 reads
The “most_recent_sql_handle” column
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...
2014-01-22
1,103 reads
PowerShell Remote Commands
This is something I've found useful here recently when I had a server acting up. It's a simple way to...
2014-01-22
1,064 reads
Easy Backup History Review Script
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
569 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the...
2014-01-21
16 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...
2014-01-21
855 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