!function(){if(void 0===window.powerbiresizescript){function L(e,t){if(e)for(var i=0;ie.children.length;i++)if(e.children[i].tagName.toLowerCase()===t.toLowerCase())return e.children[i];return null}function C(e){if(e){var t=e.parentNode,i=L(t,"div");i&&t.removeChild(i);var...
SQL SERVER – Data Scrambling
declare @AlLChars varchar(100) = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
--0123456789
--@AlLChars='123456789'
update h
set Fname= RIGHT( LEFT(@AlLChars,ABS(BINARY_CHECKSUM(NEWID())%35) + 1 ),3) + RIGHT( LEFT(@AlLChars,ABS(BINARY_CHECKSUM(NEWID())%35) +...
SQL SERVER – EXECUTE SSIS PACKAGE FROM T-SQL
/*
GET THE ENVIRONMENT_REFERENCESID WHICH
IS CONFIGURED FOR PROJECT
*/
DECLARE @REFERENCE_ID INT
SELECT @REFERENCE_ID =
REFERENCE_ID
FROM...
SQL SERVER – SCRIPT TO DROP NON CLUSTERED INDEX IF EXISTS
SELECT o.[name] AS [Table Name]
,i.[name] AS [Index
Name]
,i.[fill_factor] AS
[Existing Fill Factor]
,'IF EXISTS (SELECT * FROM SYS.INDEXES WHERE
OBJECT_id=OBJECT_ID('''+QUOTENAME(s.name)...
SQL SERVER – DENSE_RANK() – ORDER BY SOME COLUMN BUT WE SHOULD ADD WHERE FILTER WHILE ASSIGNING RANK
Just another day I received following question from my friend and I find it very interesting. I decided to try it out on SQL Server. The question was – “Can we apply Dense_Rank function order by some Column but we should add where filter while assigning...
SQL SERVER – SEQUENTIAL NUMBERS FAST LOAD TO TABLE
Problem
I need to load very fastly some sample data to database table with Sequential Numbers. We can load Sequential Numbers with Loops but it is a performance issue because it will load one record in one iteration . What is an alternative for loops...
SSIS – Combination of Parent Package Configuration and SQL Server Package Configuration along with Environment variable
Problem
As explained in this post SQL Server Package Configuration,we can able to make use of SQL Server configuration table values inside SSIS packages by using Environment variables and SQL server configuration . In SSIS Configuration table...
SSIS – SQL Server Package Configuration
Problem
After we develop SSIS Packages, if we want to move developed packages to another server/ environment ,we need to change so many configuration settings in each SSIS Packages like DB Connection strings, File path and etc. But there is so much...
SQL SERVER – RUN T-SQL SCRIPT FILES USING SQLCMD WITHOUT OPEN IN SSMS
In Software World, Source
of Knowledge is requirementJ. Today I got big SQL Script (600 MB) to execute in SSMS. But
due to big file it was not opened in SSMS. So I was searching for solution to
execute this file without opening .sql file in SSMS, I...
SQL SERVER – HOW TO DELETE ALL TABLES DATA EXCEPT TOP N RECORDS IN EACH TABLE?
I always likes logical work than regular boring work. So when I am browsing on Google, I found some interesting question like how to delete all tables’ data in SQL Server except top N records in each table?
Here is the script for delete all tables data...
SQL SERVER -- SQL SERVER 2016 WHAT'S NEW ?
1 Query Store
a) Captures queries, query plans, runtime
statistics, etc.
b) Can enforce polices to direct SQL Server Query
processor to execute in...
