T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is...
2013-02-15
1,622 reads
Backup not starting for Database with Full Text Catalog…………..Failed to change the status to RESUME for full-text catalog in database. Error: 0×80043607
Issue :-
One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending...
2013-02-14
763 reads
Connect PerfMon to a Remote Server
It seems to be a simple & easy thing to connect Perfmon to a remote server.
GO TO RUN > Perfmon > Right Click...
2013-02-14
1,265 reads
Hardware 301 Presentation
I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times...
2013-02-14
1,134 reads
SQL Server Podcasts
Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...
2013-02-14
1,590 reads
Home Power – Generators
A slightly off topic post, but since I was asked recently, I thought I’d take my reply, make a post...
2013-02-22 (first published: 2013-02-14)
2,681 reads
“DBA: Transitioning to a BI Role” Presentation Slides
Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter. The recording...
2013-02-14
1,774 reads
Start Getting Ready for PASS Summit 2013
Seems so early in the year, but it’s already time to start getting ready for this year’s PASS Summit. There...
2013-02-14
694 reads
A Month of PowerShell – Day 14 (Databases: Altering Tables)
Welcome to Day 14 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-14
2,151 reads
Script Replication with PowerShell
I promised you some PowerShell scripts this year and this post is the first one. I can see the value...
2013-02-14
6,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