DotNetShoutout

SQL Server

5
Shouts

Shout it

Process & Processor

posted by

dhara 980 days, 16 hours, 29 minutes ago

Performance Monitor a.k.a perfmon is used to monitor different counters for different purposes. However, some counters are bit confusing. Process and Processor two misleading counters so thought of putting this note. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, TSQL

6
Shouts

Shout it

Obtaining the Last Inserted Identity in SQL Server

posted by

BlackWasp 981 days, 1 hour, 20 minutes ago

SQL Server identity columns allow a sequence of numbers to be generated so that a unique number can be applied for each new row in a table. As these values are produced automatically, it is sometimes necessary to retrieve an identity after creation. (more)

category: How To | clicked: 0 | comment | | source: www.blackwasp.co.uk

| flag as spam

tags: SQL Server

6
Shouts

Shout it

Loop through each record in a text file : Recordset Destination

posted by

dhara 981 days, 17 hours, 11 minutes ago

In most ETL we use Foreach loop to iterate through each file in a folder or records fetched from a table. Now the question arises how do we use Foreach loop based on each record in a text file. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, MSBI, BI

2
Shouts

Shout it

SQL Server 2008 – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All | Senthil Kumar's Blog

posted by

http://isenthil.myopenid.com/ 982 days, 9 hours, 43 minutes ago

Have you noticed the Context Menu , when you right click on the table in the SQL Server Management Studio Express 2008 . The SQL Server Management Studio Express 2005 allows us to “Edit” or “View” the entire records in a table. You might see the following options in the SQL Server Management Studio Express 2008 . Select Top 1000 Rows Edit Top 200 Rows The idea to include this looks good for perform... (more)

category: Data | clicked: 0 | comment | | source: www.ginktage.com

| flag as spam

tags: SQL Server, trick

8
Shouts

Shout it

List out tables from linked server

posted by

dhara 982 days, 17 hours, 37 minutes ago

The system stored procedure sptables is used to list out the tables available in the current database of the current server. What if you want to know the same that exist in the linked Server? You can use sptables_ex (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, TSQL

3
Shouts

Shout it

Notifications for SQL Server Agent Restarts

posted by

Judo 982 days, 17 hours, 39 minutes ago

In this article we will set up an email notification at the SQL Server level whenever SQL Server and the SQL Server Agent Restarts. The article will useful for DBA's who support a large number of database servers which they cannot manually connect to daily to check the SQL Server status, SQL job status or SQL Server Agent status. (more)

category: Architecture | clicked: 0 | comment | | source: www.sql-server-performance.com

| flag as spam

tags: SQL Server, sql server agent

8
Shouts

Shout it

TSQL Beginners Challenge 16 - Find the palindromic words from the sentence(s) - TSQL Challenges for Beginners

posted by

dhara 983 days, 11 hours, 6 minutes ago

This challenge is to find the palindromic words from sentence(s). Palindrome is a word reading the same backward as forward. While finding the palindromic words from the sentence(s), the noise words should be removed if any is present in the sentence... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

An impossible case

posted by

dhara 983 days, 17 hours, 34 minutes ago

In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, TSQL

7
Shouts

Shout it

Findout Calling procedure name using @@PROCID

published 986 days, 7 hours, 56 minutes ago posted by

dhara 986 days, 14 hours, 7 minutes ago

Suppose you want to find out the name of the procedure that calls the procedure being executed,you can use system function @@PROCID which returns the object id of the current procedure. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

9
Shouts

Shout it

Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

published 985 days, 5 hours, 36 minutes ago posted by

dhara 986 days, 17 hours, 38 minutes ago

Around 6 months ago, I was desperately looking for some online resources to help me implement some map reports. The shapefile I was dealing with was at a very granular level (which means that it had a lot of data, 2.5 MB in size), and we needed to do some custom aggregations on the spatial data. As the custom aggregations were done at report run time, it turned out to be a major performance bottleneck. (more)

category: Data | clicked: 1 | 3 comments | | source: beyondrelational.com

tags: SQL Server, MSBI, BI, SSRS

10
Shouts

Shout it

Why we should not use cast, convert and Year() function on datetime column in where clause?

published 985 days, 5 hours, 36 minutes ago posted by

dhara 988 days, 14 hours, 3 minutes ago

This post is inspired by a discussion at MSDN forums, which is about the Performance effect of Cast,Convert and Year() functions on Datetime columns in where clause. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

SSIS File Operations – Copy File, Move File, Rename File and Delete File

published 988 days, 11 hours, 32 minutes ago posted by

dhara 988 days, 15 hours, 49 minutes ago

In the previous post we saw that how to Load data from Text files to SQL Server Tables and successfully created a package which loads data in to SQL Server table from a flat file. In this post today we will see SSIS File Operations – Copy File, Move File, Rename File and Delete File. Several times we need to do some file operations like copy, move, delete or rename file while performing the integration tasks. (more)

category: Data | clicked: 8 | comment | | source: beyondrelational.com

tags: SQL Server, SSIS, BI

5
Shouts

Shout it

Speed Dating - Using time compression instead of MDX Cubes to deliver rapid data analysis

published 988 days, 11 hours, 32 minutes ago posted by

dhara 988 days, 17 hours, 14 minutes ago

The term “data warehouse” may have originated because it once took a literal warehouse to hold all the servers you needed to store a few gigabytes of information. We now live in extraordinary times where usb drives given away as promotional items can store the equivalent. The approaches taken by data professionals have not caught up to the unfathomable progress hardware has made. (more)

category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

6
Shouts

Shout it

Is There a Shortage of SQL Server Experts?

published 988 days, 11 hours, 32 minutes ago posted by

dhara 989 days, 12 hours, 16 minutes ago

Do you think we have enough SQL Server experts? Article from Brain indicate there are shortage in SQL Server experts. (more)

category: Data | clicked: 0 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

TSQL Tips and Tricks - Different ways to know the server name

published 988 days, 11 hours, 32 minutes ago posted by

dhara 989 days, 17 hours, 46 minutes ago

Here are the three different ways to know the Server name using queries (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

SSIS - Managing Control Flow based on the input file name - Sudeep's Domain

posted by

http://rajsudeep.blogspot.com/ 994 days, 8 hours, 20 minutes ago

Many times during ETL we have a requirement where based on the file name we have to perform certain operations. Normally within a For Each Loop with File enumerator in Control Flow Task there is no direct way of doing this. If the file mask matches, well and good but nothing beyond that. I demonstrate this with a scenario: We have a lot of files in a folder and there is no specific file mask that you can be applied apart from *.txt. So you need to pick up all the files from the folder matching the above... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, For Each loop, MSBI, Control Flow, SSIS, Script Task, Precedence Constraint

5
Shouts

Shout it

To use Script Component or Derived Column Transformation?? Is the question.. - Sudeep's Domain

published 993 days, 1 hour, 35 minutes ago posted by

http://rajsudeep.blogspot.com/ 994 days, 8 hours, 39 minutes ago

This is an old debate and yet not resolved. To use Script Component or Derived Column Transformation?? Yes Derived Column Transformation can NOT do all that can be done in Script Component. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, MSBI, Derived Column, SSIS, Script Component

10
Shouts

Shout it

Script Component–Source Part1 - Sudeep's Domain

published 990 days, 9 hours ago posted by

http://rajsudeep.blogspot.com/ 994 days, 8 hours, 41 minutes ago

SSIS scenarios... One of the most advance feature of SSIS is Script design capability provided be it Script Task in Control Flow or Script Component in Data Flow Task. I have seen people use the Script task pretty often but avoid Script Component because of various reasons. Earlier I had shown how to set up user variable in Script component. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, Script Component Source, MSBI, SSIS, Script Component

12
Shouts

Shout it

Script Component–Source Part2 Retain last record - Sudeep's Domain

published 986 days, 7 hours, 56 minutes ago posted by

http://rajsudeep.blogspot.com/ 994 days, 8 hours, 44 minutes ago

Sudeep's DomainHomeContactRSS for Posts So keeping my focus on SSIS Script Component as Source I show another example. Mostly Script component is needed when source is Flat file and we need to retain the previous record value(s) to be used in the next record(s). Keeping this in mind I present the scenario:.... read on... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, Script Component Source, MSBI, SSIS, Script Component, Retain Last Record

9
Shouts

Shout it

Writing a Silverlight Application Using EntitySpaces is Incredibly Simple and Powerful

published 989 days, 21 hours, 42 minutes ago posted by

MikeGriffin 994 days, 21 hours, 31 minutes ago

Sometimes you’re so busy designing, coding, testing, and supporting a product that you don’t take the time to stop and appreciate what you have actually accomplished. A customer of ours asked us to create a video overview of our Silverlight functionality and in doing so we had to step back and say “wow”, this is pretty cool. It truly is easy to use EntitySpaces to create a Silverlight application as you will see. (more)

category: Metro | clicked: 3 | comment | | source: www.entityspaces.net

tags: SQL Server, EntitySpaces, WCF, ORM

Welcome!

SQL Server

Process & Processor

Obtaining the Last Inserted Identity in SQL Server

Loop through each record in a text file : Recordset Destination

SQL Server 2008 – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All | Senthil Kumar's Blog

List out tables from linked server

Notifications for SQL Server Agent Restarts

TSQL Beginners Challenge 16 - Find the palindromic words from the sentence(s) - TSQL Challenges for Beginners

An impossible case

Findout Calling procedure name using @@PROCID

Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

Why we should not use cast, convert and Year() function on datetime column in where clause?

SSIS File Operations – Copy File, Move File, Rename File and Delete File

Speed Dating - Using time compression instead of MDX Cubes to deliver rapid data analysis

Is There a Shortage of SQL Server Experts?

TSQL Tips and Tricks - Different ways to know the server name

SSIS - Managing Control Flow based on the input file name - Sudeep's Domain

To use Script Component or Derived Column Transformation?? Is the question.. - Sudeep's Domain

Script Component–Source Part1 - Sudeep's Domain

Script Component–Source Part2 Retain last record - Sudeep's Domain

Writing a Silverlight Application Using EntitySpaces is Incredibly Simple and Powerful

Open ID Login

Standard Login

Forgot Password?

Sign up