ashishgilhotra

ashishgilhotra
Name: ashishgilhotra
Score: 653.01
Last Seen: 123 days, 7 hours, 6 minutes ago
Member Since: 22 April, 2010
SqlServerKudos
atom rss
2
kudos
spam Kudos Remove

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!! - SQL Server News
published 113 days, 10 hours, 22 minutes ago posted by ashishgilhotraashishgilhotra 123 days, 7 hours, 6 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 1:06:44 PM GMT
SQL Server 2008 R2 Express Database Size Limit Increased to 10GB! Download Now!! - SQL Server News
So what is so exciting about the SQL Server 2008 R2 Release? Well, along with plenty of BI features and enhancements, there is a tiny cute feature that I am sure all of us will appreciate a lot. The product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have got a growing SQL Server Express database that is close to the 4 GB Limit, hurry, upgrade to R2 Express. (more)
category: Community | clicked: 0 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

Post Upgrade Experience: SQL 2000 to 2008 - Never Say Never
published 113 days, 10 hours, 22 minutes ago posted by ashishgilhotraashishgilhotra 123 days, 7 hours, 7 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 1:05:32 PM GMT
Post Upgrade Experience: SQL 2000 to 2008 - Never Say Never
Whew! So I've been super busy the past week and a half upgrading our production server from SQL 2000 to SQL 2008 and haven't had time for any new posts. Finally starting to see everything calm down again though and running smoother than ever before. I had hoped to do a comparison of 2000 and 2008 disk activity pre and post compression, but due to the number of "emergencies" in the week prior to the changeover and the number of times our plans changed with reconfiguring raid arrays etc. I never had an opp... (more)
category: Management | clicked: 0 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

TSQL Beginners Challenge 6 - Count the number of mobile phones and generate a summary - TSQL Challenges for Beginners
published 113 days, 10 hours, 22 minutes ago posted by ashishgilhotraashishgilhotra 123 days, 7 hours, 8 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 1:04:39 PM GMT
TSQL Beginners Challenge 6 - Count the number of mobile phones and generate a summary - TSQL Challenges for Beginners
This challenge aims to test your string parsing and summarizing skills using TSQL. The challenge is to count the number of mobile phones each person has and generate a summary row. (more)
category: Query | clicked: 2 | comment | | source: beyondrelational.com
2
kudos
spam Kudos Remove

Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files - Ashish's Blog On SQL Server
published 113 days, 10 hours, 22 minutes ago posted by ashishgilhotraashishgilhotra 123 days, 7 hours, 9 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 1:03:50 PM GMT
Loading data from text files to SQL Server Tables – CSV Files, Tab Separated Files or Fixed Column Length Files - Ashish's Blog On SQL Server
In the previous post we looked in How to Execute SQL Query or Store Procedure from SSIS and successfully created a package which execute SQL Query or Procedure on targeted SQL Server with the help of this. In this post we look in How to Load Data from text Files to SQL Server, in daily life several time we need to load data in SQL Server tables, we can achieve this with the help of SSIS. We look into the detailed process of loading data from text files to SQL Server tables. (more)
category: Warehousing | clicked: 1 | comment | | source: beyondrelational.com
3
kudos
spam Kudos Remove

DotNetShoutout - SQL Server – Issues with generating XML using string operations
published 123 days, 11 hours, 6 minutes ago posted by ashishgilhotraashishgilhotra 132 days, 8 hours, 6 minutes ago
Friday, May 07, 2010 9:06:17 AM GMT Wednesday, April 28, 2010 12:06:43 PM GMT
DotNetShoutout - SQL Server – Issues with generating XML using string operations
Building XML documents using string functions – concatenating XML tags and embedding values between them using string operations – is not a recommended method. This post tries to look into some of the problems this approach can bring in.. (more)
category: Query | clicked: 1 | comment | | source: dotnetshoutout.com
4
kudos
spam Kudos Remove

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database
published 124 days, 11 hours, 11 minutes ago posted by ashishgilhotraashishgilhotra 134 days, 5 hours, 32 minutes ago
Thursday, May 06, 2010 9:01:20 AM GMT Monday, April 26, 2010 2:40:30 PM GMT
TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database
The challenge is to write a query that returns the articles to be displayed in the home page of the website. (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
3
kudos
spam Kudos Remove

FOR XML Workshop – Understanding FOR XML RAW
published 128 days, 11 hours, 27 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 9 hours, 26 minutes ago
Sunday, May 02, 2010 8:45:05 AM GMT Thursday, April 22, 2010 10:46:33 AM GMT
FOR XML Workshop – Understanding FOR XML RAW
This post explains how to generate XML documents using FOR XML RAW from TSQL (SQL Server) (more)
category: Query | clicked: 1 | comment | | source: beyondrelational.com
3
kudos
spam Kudos Remove

Adding breadcrumbs to your drillthrough reports
published 131 days, 11 hours, 42 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 9 hours, 33 minutes ago
Thursday, April 29, 2010 8:30:15 AM GMT Thursday, April 22, 2010 10:39:40 AM GMT
Adding breadcrumbs to your drillthrough reports
This post shows a trick that helps you to build breadcrumbs in SSRS drill through reports. (more)
category: Reporting | clicked: 0 | comment | | source: beyondrelational.com
3
kudos
spam Kudos Remove

Too many indexes, Is it a problem?
published 128 days, 11 hours, 27 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 10 hours, 22 minutes ago
Sunday, May 02, 2010 8:45:05 AM GMT Thursday, April 22, 2010 9:50:28 AM GMT
Too many indexes, Is it a problem?
We discussed in previous posts, how important to create index on your tables or views. However, next question will come to you what is number of indexes that you can create or will the be a performance decrease on number of indexes you create? In all... (more)
category: Query | clicked: 1 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

SELECT INTO is faster than CREATE & INSERT
published 129 days, 11 hours, 32 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 12 hours, 15 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 7:57:02 AM GMT
SELECT INTO is faster than CREATE & INSERT
This article explain Why SELECT.. INTO is faster than CREATE and INSERT... (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

SSRS reports using embedded images
published 131 days, 11 hours, 42 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 12 hours, 26 minutes ago
Thursday, April 29, 2010 8:30:15 AM GMT Thursday, April 22, 2010 7:45:57 AM GMT
SSRS reports using embedded images
This post demonstrates how to use embedded images on your report based on a condition... (more)
category: Reporting | clicked: 1 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

SQL Server - Case Sensivity and Accent sensivity determined by a Collation
published 129 days, 11 hours, 32 minutes ago posted by ashishgilhotraashishgilhotra 138 days, 12 hours, 27 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 7:44:52 AM GMT
SQL Server - Case Sensivity and Accent sensivity determined by a Collation
Sql server 2005/2008 support Unicode characters so you can present your data in any language so for example if your Database collation is (a Latin) and you want to store Arabic language words ,you need to define Unicode data type columns like(nchar,nvarchar,ntext) to stored your data properly and to avoid the question marks problem (???) except if your database collation is Arabic and in this case it does not need to define your columns as a Unicode type because you can use the type like(char,varchar,tex... (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
4
kudos
spam Kudos Remove

SQL Server 2008 R2 Released (RTM) – Download it or try the Hosted version from PASS! - SQL Server Community Blogs
published 129 days, 11 hours, 32 minutes ago posted by jacobsebastianjacobsebastian 138 days, 14 hours, 11 minutes ago
Saturday, May 01, 2010 8:40:08 AM GMT Thursday, April 22, 2010 6:01:31 AM GMT
SQL Server 2008 R2 Released (RTM) – Download it or try the Hosted version from PASS! - SQL Server Community Blogs
SQL Server 2008 R2 is officially released. See this post for a number of resources to help you to get started with SQL Server 2008 R2. (more)
category: News | clicked: 0 | comment | | source: beyondrelational.com
tags: sqlserver r2