|
|
-
|
|
Technically, JQuery is a JavaScript library. JavaScript is a subset of Java and a scripting language which runs on the client side i.e. on web browsers. There are many popular JavaScript library/framework available today such as MooTool, JavaScriptMVC, qoo...
|
|
-
|
|
Technology,networking,knowledge sharing under one roof and that too for 3 consecutive days !!! Wow,thats TechEd for you.
[Picture courtesy - http://yodigo-contrablog.blogspot.com]
TechEd India 2012 gave me a fabulous ride this time.Even though I couldn...
|
|
-
|
|
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in management studio. When I learn something, you have to read it. I apologize, but you have to read it. As Ellen DeGeneres says, “if I see something… you...
|
|
-
|
|
I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sort_warning and hash_warnig. In SQL Server 2008R2, we can create SQL Trace to capture sort and hash warnings but there is no easy w......
|
|
-
|
|
There are a few design choices that can make your SSIS packages run super fast when loading data from table A to table B.
SQL Command at Source
OLE DB source editor allows you to choose either a table or a view from a drop down if data access mode is Table...
|
|
-
|
|
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx
However, Whenever I faced a situation to concatenate the values in a table there was always a req......
|
|
-
|
|
This post shows how you can generate hyperlink in excel output file using Script Task Reading data and exporting it to Excel is one of the very common task in SSIS professional life. One of the very intersting thing which I come across is generating Hyperl...
|
|
-
|
|
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was given this query to improve, as it was taking over 15 hours to run:
SELECT *
FROM
(
SELECT * FROM
GL_Star_FactsDetails GL
LEFT JOIN DimAccount ACCT on GL.Account = ACCT.AccountRapidDe......
|
|
-
|
|
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular. So when you are creating a new project, which model should you use, Multidimensional vs Tabular? Well, there is...
|
|
-
|
|
SQL Server Denali brings us new string function, FORMAT function. It will make formatting of date/time and number values easier.
Syntax: FORMAT (value, format [,culture])
Formatting Date/Time
Let’s see how it works:
DECLARE @a datetime = getdate()
-- If the culture argument is not provide......
|
|