DotNetShoutout

pinaldave

Name:	pinaldave
Score:	3,063.4
Last Seen:	345 days, 12 hours, 52 minutes ago
Member Since:	23 January, 2009

15
Shouts

Shout it

SHRINKDATABASE For Every Database in the SQL Server

published 1015 days, 15 hours, 39 minutes ago posted by

pinaldave 1016 days, 42 minutes ago

This article is an interesting story of Shrinking the Database. Do you Shrink your database - learn the story today! (more)

category: Data | clicked: 0 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

Getting started with PIVOT Queries in SQL Server 2005/2008 - Jacob's Blog

published 1016 days, 13 hours, 24 minutes ago posted by

jacobsebastian 1017 days, 1 hour, 21 minutes ago

This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the pas (more)

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

tags: SQL Server, Databases, internet, TSQL, pivot, Microsoft, Cross Tab

10
Shouts

Shout it

SQL Server - Quick and Easy auditing using host_name() and user_name() functions - Madhivanan's TSQL Blog

published 1015 days, 15 hours, 39 minutes ago posted by

jacobsebastian 1016 days, 15 hours, 32 minutes ago

This post demonstrates a few quick and easy methods to audit the data modifications on your SQL Server Database using the hostname() and username() system functions. (more)

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

tags: SQL Server, Databases, internet, DBA, user_name, host_name, TSQL, Microsoft

10
Shouts

Shout it

Binding A Custom Entity Class to stored procedure using Linq-To-SQL - DotNetJaps-SQL

published 1016 days, 13 hours, 24 minutes ago posted by

jacobsebastian 1017 days, 18 hours, 3 minutes ago

The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL (more)

category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com

tags: Linq To SQL, dotnet, Linq

9
Shouts

Shout it

How to load a huge file into a FILESTREAM column quickly - Jacob's Blog

published 1016 days, 13 hours, 24 minutes ago posted by

jacobsebastian 1018 days, 3 minutes ago

This post shows a quick and dirty way of loading a huge file into the FILESTREAM column of a SQL Server 2008 database instance. (more)

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

tags: DBA, TSQL, SQLServer, FILESTREAM

10
Shouts

Shout it

Interesting enhancements to the VALUES Clause in SQL Server 2008 - Madhivanan's TSQL Blog

published 1017 days, 17 hours, 11 minutes ago posted by

jacobsebastian 1018 days, 17 hours, 55 minutes ago

With SQL Server 2008, you can do many more interesting things using VALUES clause than the previous versions.The following examples will explain it's various usages in detail (more)

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

tags: TSQL, SqlServer 2008, SQLServer

11
Shouts

Shout it

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters - TSQL Challenges for Beginners

published 1018 days, 13 hours, 11 minutes ago posted by

jacobsebastian 1019 days, 23 hours, 57 minutes ago

The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E" (more)

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

tags: Puzzle, TSQL, SQLServer, challenge

12
Shouts

Shout it

LINQ to SQL Query Operators Part II - Imran's Blog

published 1020 days, 13 hours, 11 minutes ago posted by

jacobsebastian 1021 days, 15 hours, 29 minutes ago

This installment of the LINQ tutorial series explains how to perform grouping on data and perform set operations and joins in a LINQ query (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: dotnet, C#, joins, Linq, grouping

12
Shouts

Shout it

What is Silverlight - Dinesh's Blog

published 1020 days, 13 hours, 11 minutes ago posted by

jacobsebastian 1020 days, 20 hours, 48 minutes ago

This article explains what Silverlight is and how it fits into the web spectrum and in Building Business Applications. It demonstrates the programming model for Silverlight and will be very helpful for the beginners as well as people who already has started working with silverlight. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: Silverlight

6
Shouts

Shout it

SQL SERVER – Computed Column – PERSISTED and Performance

published 1023 days, 16 hours, 3 minutes ago posted by

pinaldave 1024 days, 12 hours, 47 minutes ago

Did you know computed columns are computed at run time? Yes or No? If yes, you know the answer of following question: Is it better with performance or not? If no, go on and read it... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

10
Shouts

Shout it

SQL Server - Difference between TSQL Functions CAST() and CONVERT() - Madhivanan's TSQL Blog

published 1025 days, 15 hours, 57 minutes ago posted by

jacobsebastian 1026 days, 21 hours, 48 minutes ago

This post explains the differences between TSQL functions CAST() and CONVERT(). Though they seem identical, there are several differences between these functions. (more)

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

tags: Convert, TSQL, Cast, SQLServer

6
Shouts

Shout it

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

published 1025 days, 15 hours, 57 minutes ago posted by

pinaldave 1026 days, 12 hours, 11 minutes ago

In one of the recent consultancy, I was asked if I can give working example of BINARYCHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows. However, if the row is changed from A to B and once again changed back to A, the BINARYCHECKSUM cannot be used to detect the changes. Let us see quick example of the of same. Following example is modified from the original example taken from BOL. U... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

The Self Join – Inner Join and Outer Join - An Example

published 1048 days, 13 hours, 55 minutes ago posted by

pinaldave 1048 days, 20 hours, 40 minutes ago

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

published 1057 days, 13 hours, 6 minutes ago posted by

pinaldave 1058 days, 1 hour, 44 minutes ago

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed below. You will be successfully able to test multiple instances of SQL Server using this tool. Once the tool is launched, select the product you wish to analysis. Click on Start Scan will take few minut... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Statistics without Index - Possible and Helpful

published 1059 days, 14 hours, 5 minutes ago posted by

pinaldave 1061 days, 53 minutes ago

A Simple note about the subject, how statistics can be helpful and how they are created. (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Getting Started with Bing Map in Silverlight

published 1064 days, 17 hours, 37 minutes ago posted by

jacobsebastian 1064 days, 21 hours, 52 minutes ago

This post explains how to get started with Bing Map and Silverlight. This is first of a series of posts which explains how to build geo-spatial solutions using silverlight, bing maps based on the data stored in a SQL Server database. (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: Silverlight, Bing, maps, SQLServer, Geospatial

11
Shouts

Shout it

Understanding Datetime column - Part III - Madhivanan's TSQL Blog

published 1064 days, 17 hours, 37 minutes ago posted by

jacobsebastian 1065 days, 18 hours, 13 minutes ago

Another post in the 'datetime tutorial series' which shows several tips and tricks that can be used while writing TSQL Queries that need to perform date calculations in the WHERE clause. (more)

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

tags: DateTime, SQLServer

6
Shouts

Shout it

TSQL Beginners Challenge 10 - Clean up alphanumeric strings by splitting digits and letters into separate columns - TSQL Challenges for Beginners

published 1064 days, 17 hours, 37 minutes ago posted by

ashishgilhotra 1066 days, 15 hours, 12 minutes ago

This challenge refers to sanitizing text data. Your task is to read an alphanumeric string and create two output columns one containing all the digits found in the input string and the other with all the letters of the English Alphabet. (more)

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

5
Shouts

Shout it

Find Data Stored in SQL Server Cache

published 1067 days, 13 hours, 15 minutes ago posted by

pinaldave 1068 days, 2 hours, 46 minutes ago

A Common Question: Can I see what data is cached in my SQL Server Memory? A Simple Answer: Yes. (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

Shrink, MDF, NDF and Reader's Opinion - What's Yours?

published 1071 days, 14 hours, 7 minutes ago posted by

pinaldave 1073 days, 19 hours, 2 minutes ago

Blog Reader and SQL Expert Imran has wonderful explanation of how Shrinking, MDF and NDF works. What is your opinion? (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

Welcome!

pinaldave

SHRINKDATABASE For Every Database in the SQL Server

Getting started with PIVOT Queries in SQL Server 2005/2008 - Jacob's Blog

SQL Server - Quick and Easy auditing using host_name() and user_name() functions - Madhivanan's TSQL Blog

Binding A Custom Entity Class to stored procedure using Linq-To-SQL - DotNetJaps-SQL

How to load a huge file into a FILESTREAM column quickly - Jacob's Blog

Interesting enhancements to the VALUES Clause in SQL Server 2008 - Madhivanan's TSQL Blog

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters - TSQL Challenges for Beginners

LINQ to SQL Query Operators Part II - Imran's Blog

What is Silverlight - Dinesh's Blog

SQL SERVER – Computed Column – PERSISTED and Performance

SQL Server - Difference between TSQL Functions CAST() and CONVERT() - Madhivanan's TSQL Blog

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

The Self Join – Inner Join and Outer Join - An Example

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

Statistics without Index - Possible and Helpful

Getting Started with Bing Map in Silverlight

Understanding Datetime column - Part III - Madhivanan's TSQL Blog

TSQL Beginners Challenge 10 - Clean up alphanumeric strings by splitting digits and letters into separate columns - TSQL Challenges for Beginners

Find Data Stored in SQL Server Cache

Shrink, MDF, NDF and Reader's Opinion - What's Yours?

Open ID Login

Standard Login

Forgot Password?

Sign up