-
Pro SQL Server 2012 Reporting Services, 3rd edition
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost.…
-
Expert Performance Indexing for SQL Server 2012
If you are looking for expert performance indexing for SQL Server 2012, you may try to download SQL Server 2012…
-
SQL Server 2005 Service Pack Downloads
SQL Server 2005 Service Pack Downloads This is a page of SQL’s featured download references. Get service packs, add-ins, tools,…
-
Microsoft SQL Server Management Studio Express
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express…
-
Sql : Database Unknown Owner
SELECT Name AS DBName,suser_sname(sid) AS Owner FROM master.dbo.sysdatabases WHERE suser_sname(sid) IS NULL If you get any results, you can set…
-
SQL : Clone Table
This is short articel – Clone Table Script, we have seen how we can backup or create clone via using…
-
SQL: ALTER Columns Statement to update NULLs to Not NULLs
SQL: This example updates allow NULLs to Not Nulls. ALTER TABLE dbo.tbl_temp ALTER COLUMN UserName VARCHAR(256) NOT NULL
-
SQL – Server – Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Chinese_PRC_CI_AS”
Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Chinese_PRC_CI_AS” in the equal to operation. Check YourFieldName NVARCHAR(20) in Create Table…
-
SQL Server – finding duplicate records in sql
The col1 in a table that exist more than once. SELECT Col1, COUNT (Col1) AS NumOccurrences FROM TBL GROUP BY Col1…
