|
SSIS dedicated Server Hardware
|
14
|
May 21, 2020
|
|
Data migration
|
3
|
May 20, 2020
|
|
ALTER VIEW must be the only statement in the batch
|
20
|
May 12, 2020
|
|
Remove duplicates based on 1 field
|
6
|
May 7, 2020
|
|
Top 10, count Distinct of multiple columns in select statement
|
6
|
April 10, 2020
|
|
Blocking issue
|
6
|
April 1, 2020
|
|
View- Stored Procedure Tuning
|
10
|
March 21, 2020
|
|
Two identical agent jobs 1 works 1 doesn't
|
3
|
March 9, 2020
|
|
Generating a unique code for a table column value & saving it in the table
|
3
|
March 5, 2020
|
|
Getting top records resultset in a specified format
|
2
|
February 26, 2020
|
|
SQL Server
|
18
|
February 24, 2020
|
|
To show the count per month from the date provided
|
5
|
February 22, 2020
|
|
Avoiding too may temp tables & tweak the query
|
4
|
February 18, 2020
|
|
Need to avoid NULL & replace with 0 in the result
|
5
|
February 15, 2020
|
|
Retrieve activities "Followed By" certain activities in SQL
|
21
|
January 18, 2020
|
|
Deleting records from tables related by foreign key
|
7
|
January 10, 2020
|
|
Free add-in for "SELECT * FROM" in Management Studio
|
4
|
January 1, 2020
|
|
Creating new database from saved database scripts
|
6
|
December 29, 2019
|
|
SSIS deployment through command prompt
|
1
|
December 27, 2019
|
|
Value based on sequence for each detail
|
6
|
December 16, 2019
|
|
Query using cast on XML data
|
6
|
December 12, 2019
|
|
SQL Server Stored Procedure execution from SSIS task
|
3
|
December 12, 2019
|
|
Make ranges with consecutive ports # and system#
|
5
|
December 6, 2019
|
|
Need to have ordered results in one shot query instead of 3 queries
|
3
|
November 27, 2019
|
|
SELECT statement on a stored procedure
|
3
|
November 22, 2019
|
|
How to log send new or modified records (for FTP purposes)
|
1
|
November 16, 2019
|
|
Get history tracks
|
5
|
November 15, 2019
|
|
Calculate a current row value depending on the previous and next values
|
22
|
November 12, 2019
|
|
SQL query for custoemr retention
|
10
|
November 9, 2019
|
|
I have Three tables, which need to be joined and columns to be computed based on their values
|
3
|
November 9, 2019
|
