Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
2012-08-08 (first published: 2012-08-02)
3,359 reads
Quebec Human Rights Commission Ignores Racism Documented by CRT Judge (Civil Evidence), Ignores E-mail Evidence & Botches Up Investigation
After seeking justice in this matter for years, I am obliged to bring this issue up again (since it affects...
2012-08-02
1,253 reads
Auto Shrink of all T-Log File on a SQL Instance - TSQL
This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...
2012-08-02
2,660 reads
Replace NOT IN with JOIN
Example of how to replace NOT IN clause with JOIN
/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);
/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;
2012-08-02
4,762 reads
SQL security scripting - TSQL
SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...
2012-08-02
1,294 reads
SQL Server 2012 – Enter the EOMONTH Function
In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End...
2012-08-02
1,786 reads
SQL database Incremental Shrink TSQL
When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...
2012-08-02
12,868 reads
Performing Unattended Installs of SQL Server 2012
In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...
2012-08-02
9,917 reads
SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure
In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...
2012-08-01
820 reads
SQL Server 2008 R2 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has...
2012-08-01
2,145 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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