tsqlchallenge's profile picture.

TSQL Challenge

@tsqlchallenge

How to use the Editor: ---------- ***How can I format my text?*** ---------- The WMD editor provided by bey... bit.ly/29HmZfR


Different methods to extract decimal part from a number: One of the questions asked in a forum.  "What are the... bit.ly/1gJCmTY


Example of SQL CLR in SQL Server: After writing some previous posts of replication and mirroring, today i am w... bit.ly/OeWfoG


#0322 - SQL Server - Why is it not a good idea to implement NOT NULL check as a CHECK constraint: I continue t... bit.ly/1j4xk1B


#0321 - SQL Server - Each GROUP BY expression must contain at least one column that is not an outer reference.... bit.ly/1dA9ZEn


MDX+SSAS #37-Ignore unrelated dimension or not: In Adventure Works cube 2008 or 2012, in the Dimension Usage t... bit.ly/1kowsYD


#0320 - SQL Server - Dropping multiple constraints in a single statement: A couple of months ago, I read a pos... bit.ly/1aqD1Gx


Understanding how ISNUMERIC function works: Often I hear from people that ISNUMERIC function is not working pr... bit.ly/1kCdTxD


6 Desktop BI Tools: Recently, I finished a project which involves using the Excel, R Project, and es-series in... bit.ly/1jDL7wb


Add new articles in existing publication without Reinitialize All Subscriptions - SQL Server Replication: Last... bit.ly/KsLtJN


#0319 - SQL Server - CTE and UNION: I was recently asked a very interesting question at work. Someone wanted t... bit.ly/K7mUC6


#0317 - SQL Server - A confession - Why you should not work on multiple tasks when writing a deployment script... bit.ly/1ikpXTc


Question of the month January 2014 - How does invalid alias work in INSERT statement?: Consider the following ... bit.ly/1cZlunO


#0316 - SQL Server - sp_help and multi-part naming of objects - Msg 102 - Incorrect syntax near '.': I was rec... bit.ly/1a0NzGT


#0315-SQL Server-Different ways to check for existence of an object (table/SP, etc): I was recently reviewing ... bit.ly/1kbrRdb


New parallel computing architechture for data from both database and hadoop: Hadoop is an outstanding distribu... bit.ly/1d7o7QL


#0314-SQL Server-Identify records with special characters using regular expressions: One of my team mates was ... bit.ly/1ggJhQv


Happy holidays in a TSQL style: In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the ... bit.ly/19npblE


#0313 - SQL Server - sp_help returns double the field length for Unicode characters: Recently, I was asked a g... bit.ly/1kJTuaW


Identify datatype of variable/column value using SQL_VARIANT_PROPERTY function: Pinal Dave, Blogger,Speaker an... bit.ly/1dXGYzB


Loading...

Something went wrong.


Something went wrong.