Archive

RSSData Modeling (4)

Date Title Comments Rating
2011-02-23 Modeling Types 0 None
2011-02-20 Physical Data Model 0 5
2011-02-20 Logical Data Model 0 5
2011-02-20 Conceptual Data Model 0 5

RSSData Warehouse (3)

Date Title Comments Rating
2011-03-17 Data Warehouse Testing 0 5
2011-03-17 Organize Data Warehouse Objects 0 5
2011-02-18 Types of Data Warehouse Dimension 0 5

RSSDefinition (4)

Date Title Comments Rating
2011-02-19 Role-playing dimension 0 3
2011-02-19 Degenerate Dimension 0 None
2011-02-19 Junk dimension 0 4
2011-02-19 Conformed dimension 0 None

RSSDownloads (1)

Date Title Comments Rating
2013-08-26 Download PowerPivot V1 0 None

RSSExternal (0)

Date Title Comments Rating

RSSGeneral (9)

Date Title Comments Rating
2014-05-25 Use NOT IN operator carefully 0 None
2013-07-17 T-SQL to get string between two strings 0 None
2012-12-14 Load Delimited CSV file using ACE Driver 0 None
2011-09-22 EOMONTH () Function in SQL Server Denali 0 5
2011-09-22 CHOOSE() function in SQL Server Denali 0 1
2011-03-11 AdventureWorks Sample Databases for SQL Server Denali 0 None
2011-03-01 SQL Server 2008 R2 Cumulative Update 5 released 0 None
2011-02-27 BigQuery by Google 0 3
2011-02-18 Using SQL Server Query Analyzer 0 None

RSSSQL Server Analysis Services (2)

Date Title Comments Rating
2011-03-14 MDX - What is Set? 0 None
2011-03-14 MDX - What is Tuple? 0 5

RSSSQL Server Denali (8)

Date Title Comments Rating
2011-03-12 Contained Database 0 None
2011-03-07 SQL Server Tools code-named “Juneau” 0 None
2011-03-05 Using Contained Database 0 5
2011-03-03 Contained Database - SQL Server 2011 - Denali 0 None
2011-03-01 What is Columnstore Index 0 None
2011-02-24 Programmability Enhancements for EXECUTE Statement 0 None
2011-02-24 Pagination with SQL Server 2011 (Denali) 0 5
2011-02-19 Whats new SQL Server “Denali” – SQL Server 2011 0 None

RSSSQL Server Partitioning (3)

Date Title Comments Rating
2011-02-25 T-SQL Find Number Of Records In a Partitioned Table 0 5
2011-02-24 SQL Server Partitioned Tables 0 4
2011-02-22 T-SQL Get Partition Details 0 4.5

RSSSQL Server Scripts (21)

Date Title Comments Rating
2013-01-30 Proper Case T-SQL 0 None
2012-12-14 Load Delimited CSV file using ACE Driver 0 None
2012-09-20 Stored Proc for Trigger using XML 0 4
2012-07-20 Remove Non Alphanumeric Characters 0 1
2011-03-21 Generate insert data script 0 5
2011-02-28 Inside SQL Server Stored Procedure 0 None
2011-02-26 Considering time by excluding overlapping and gaps 0 None
2011-02-22 T-SQL Get Partition Details 0 4.5
2011-02-21 Convert decimal to binary 0 5
2011-02-21 Convert binary to decimal 0 None
2011-02-17 T-SQL to Convert rows into single column 0 5
2011-02-17 T-SQL to create random number 0 4
2011-02-17 Convert alphanumeric phone numbers to Numeric 0 None
2011-02-16 T-SQL to find number of string occurrences with in a string 0 5
2011-02-15 Grouping Sets in SQL Server 2008 0 None
2011-02-15 Script foreign keys related to main primary table 0 None
2010-04-30 Configure Database Mail 0 None
2010-04-29 SQL Server Partition Details 0 None
2010-04-29 Script to generate calender for a month 0 None
2009-09-10 User defined function to split string by delimiter 0 None
2009-08-16 Update column in sequential order 1 None

RSSSQL Server Tips & Tricks (1)

Date Title Comments Rating
2009-11-02 Interesting - Huge performance gain while inserting data 0 3

RSSWhitepaper (1)

Date Title Comments Rating
2011-03-10 Database design tricks using Mathematics 0 5

Uncategorized (4)

Date Title Comments Rating
2017-03-22 SQL SERVER 2016: JSON Support 0 None
2012-06-26 IIF() in SQL 2012 0 None
2012-04-26 OFFSET & FETCH options in SQL 2012 0 None
2011-11-04 Root Cause behind DBProject Error 628 TSD01261 0 5

Total

59 posts
1 comments
37 raters

Category

Recent Posts

Tag cloud