The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’. For…
Microsoft SQL Server // ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = “Dsn=DsnName;” + “Uid=UserName;” + “Pwd=Secret;”;…
Database statistics The most important resource to any SQL optimizer is the statistics collected for different tables within the catalog.…
Keep software up to date It may seem obvious, but ensuring you keep all software up to date is vital…
Application Security is a primary concern of every mobile application developer whether it is iPhone app, iPad app, Universal app…
USE tempdb GO -- Create Table CREATE TABLE TestTable (Col1 INT, Col2 VARCHAR(100)) GO -- Insert Data INSERT INTO TestTable…
SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('m','y', 'c', 'tips', NULL); -- Query 2…
Using INFORMATION_SCHEMA SELECT 'UPDATE ' + T.TABLE_SCHEMA + '.' + T.TABLE_NAME + ' SET ModifiedDate = GETDATE() WHERE ModifiedDate IS NULL;'…
Instance of SQL Server 2012 and here is what we would in the configuration manager. Now, I would go ahead…
Querying Pattern Ranges The % wildcard character represents any number of characters of any length. Let’s find all first…
–SQL Server 2012 WITH CTE_SoldProduct AS ( SELECT SUM(Quantity) QNT,ProductID FROM dbo.TBL_Sales GROUP BY ProductID ) SELECT P.NAME ,P.Price ,SP.QNT…
If you want to generate a new Guid (uniqueidentifier) in SQL server the you can simply use the NEWID() function.…
1-Opening VS2010 Projects and Not Breaking Things Remember when VS2010 came out? Remember wanting to use it on your team?…
If you have collected trace using either SQL Server Profiler or an Extended Events session, you can capture SP:Recompile event in your…
Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure it became trivial. Here’s…