A Learning Experiment at SQL Saturday #187– Richmond
In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back...
2013-02-27 (first published: 2013-02-25)
1,157 reads
Benchmark SQL Server Disk Latency
Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...
2013-03-06 (first published: 2013-02-25)
4,539 reads
Last Weeks Top 10 “Reading” Links #21
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-25
1,008 reads
A Month of PowerShell – Day 25 (Integrity Checks)
Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-07 (first published: 2013-02-25)
2,318 reads
SQL Saturday #187 Richmond And More
In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll...
2013-02-25
892 reads
DROP and CREATE vs ALTER
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...
2013-03-05 (first published: 2013-02-25)
5,183 reads
Building My Next Workstation–Part 2
Building a computer, at least in the beginning, feels like something you have to do holistically and at the same...
2013-02-25
1,266 reads
SQL BLOG: Calculating total number of days from 1st Jan without using DATEDIFF function
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
904 reads
Managing Critical Server Lists with Remote Desktop Connection Manager
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,648 reads
Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test
For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from...
2013-02-25
1,373 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