kinj312

kinj312
Name: kinj312
Score: 2,488.52
Last Seen: 404 days, 16 hours, 7 minutes ago
Member Since: 26 October, 2010
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

Filtering within Object Explorer – Underappreciated features of Microsoft SQL Server
published 836 days, 2 hours, 44 minutes ago posted by dharadhara 837 days, 17 hours, 18 minutes ago
Thursday, February 03, 2011 9:21:07 PM GMT Wednesday, February 02, 2011 6:47:32 AM GMT
Continuing my series on the underappreciated features of Microsoft SQL Server (based on the editorial with the same name by Andy Warren on SQLServerCentral.com), we will today look at a very simple, productivity enhancing feature of the Object explorer – filtering! The problem When working on a complex... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL, BI
8
Shouts
spam Shout it Mute it

Implementing Drag in ASP.NET Grid using JQuery
published 836 days, 2 hours, 44 minutes ago posted by dharadhara 837 days, 17 hours, 17 minutes ago
Thursday, February 03, 2011 9:21:07 PM GMT Wednesday, February 02, 2011 6:48:40 AM GMT
Problem We have two Grid Views namely Patients and Messages side by side that contains records. When the record gets selected, we need to make the grid records drag able. We need to give provision to drag and place (not Drag & Drop) the record in another grid view record and vice versa. As a result... (more)
category: Web Dev | clicked: 3 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
7
Shouts
spam Shout it Mute it

Modulus operator in SQL Server - Madhivanan's TSQL Blog
published 836 days, 2 hours, 44 minutes ago posted by dharadhara 837 days, 17 hours, 19 minutes ago
Thursday, February 03, 2011 9:21:07 PM GMT Wednesday, February 02, 2011 6:46:04 AM GMT
Modulus operator is used to find the remainder after the division. All programming languages have specific operators to find a remainder like mod, rem, etc. In SQL Server, we can use modulus operator %. However we can also use general approach to find a remainder. Here are two methods Method 1 : Use... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

HTTP Module in detail
published 842 days, 20 minutes ago posted by dharadhara 842 days, 17 hours, 59 minutes ago
Friday, January 28, 2011 11:45:09 PM GMT Friday, January 28, 2011 6:06:42 AM GMT
I know this post may sound like very beginner level. But I have already posted two topics regarding HTTP Handler and HTTP module and this will explain how http module works in the system. I have already posted What is the difference between HttpModule... (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: .NET, ASP .NET
6
Shouts
spam Shout it Mute it

Object Explorer Details (Part II) – Underappreciated features of Microsoft SQL Server
published 842 days, 20 minutes ago posted by dharadhara 842 days, 17 hours, 58 minutes ago
Friday, January 28, 2011 11:45:09 PM GMT Friday, January 28, 2011 6:07:42 AM GMT
As mentioned in my previous post, I am currently developing a series of brief articles on the many underappreciated features of Microsoft SQL Server as received from the community as a response to Andy Warren’s SQLServerCentral.com’s editorial... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL, BI
7
Shouts
spam Shout it Mute it

Converting a BIGINT datetime
published 843 days, 6 hours, 6 minutes ago posted by dharadhara 843 days, 18 hours, 3 minutes ago
Thursday, January 27, 2011 5:59:34 PM GMT Thursday, January 27, 2011 6:02:23 AM GMT
An application I support uses a BIGINT to store date and time data. Our installation is SQL Server 2005, so the lack of accuracy in the datetime data type is probably a driver behind this. A small challenge when working with the application’s database is working out the date and time against each... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Extracting Images from SSRS reports
published 843 days, 6 hours, 6 minutes ago posted by dharadhara 843 days, 18 hours, 5 minutes ago
Thursday, January 27, 2011 5:59:34 PM GMT Thursday, January 27, 2011 6:00:32 AM GMT
What do you do when you want to re-use an image in one of those old forgotten reports that was developed by that weird guy who left your company an year ago? No matter how much you hate or abuse that guy now, it is not going to do you any good as he didn’t save those images in a source or version control... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, BI, SSRS
7
Shouts
spam Shout it Mute it

SQL Server's equivalent of MS Access functions - Part I - Madhivanan's TSQL Blog
published 846 days, 5 hours, 57 minutes ago posted by dharadhara 846 days, 18 hours, 15 minutes ago
Monday, January 24, 2011 6:08:42 PM GMT Monday, January 24, 2011 5:50:32 AM GMT
Sometimes when you want to migrate from MS Accesss to SQL Server, you need to rewrite the queries compatible to SQL Server. As you know the basic systax is same but the functions used in Access should be replaced with their equivalent in SQL Server. Here... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, MS Access
7
Shouts
spam Shout it Mute it

TSQL Challenge 47 - Read the modification history and identify the first and last card numbers
published 846 days, 5 hours, 57 minutes ago posted by dharadhara 846 days, 18 hours, 16 minutes ago
Monday, January 24, 2011 6:08:42 PM GMT Monday, January 24, 2011 5:49:12 AM GMT
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made. Red Gate SQL Source Control is the official sponsor... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
6
Shouts
spam Shout it Mute it

Finding Odd numbers from a Range of Number using LINQ in C#
published 890 days, 7 hours, 18 minutes ago posted by dharadhara 892 days, 17 hours, 48 minutes ago
Saturday, December 11, 2010 4:47:49 PM GMT Thursday, December 09, 2010 6:17:51 AM GMT
This article will show you , how could we use Predicate , Anonymous method and Lambdas with LINQ to find out all odd numbers from a range of number. ... (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: .NET, Linq, ASP.NET
7
Shouts
spam Shout it Mute it

TSQL Enhancements in SQL11 (SQL Server 2011 / Denali) to support Server Side Paging - Jacob's Blog
published 895 days, 6 hours, 20 minutes ago posted by dharadhara 895 days, 18 hours, 3 minutes ago
Monday, December 06, 2010 5:45:28 PM GMT Monday, December 06, 2010 6:02:02 AM GMT
Server Side Paging is a common scenario most application developers must have encountered while creating front end applications that requires paging support. Instead of returning all the rows from the database and implement paging at the client side,... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, denali
7
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 20 - Play Mangled Words game in TSQL
published 896 days, 15 hours, 25 minutes ago posted by dharadhara 897 days, 17 hours, 51 minutes ago
Sunday, December 05, 2010 8:40:15 AM GMT Saturday, December 04, 2010 6:14:02 AM GMT
Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL. Your task is to process the input table that contains several mangled words... (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
6
Shouts
spam Shout it Mute it

SQL Server Agent Not getting started after a Restart of Services Post Fresh Installation
published 901 days, 14 hours, 8 minutes ago posted by dharadhara 901 days, 18 hours, 13 minutes ago
Tuesday, November 30, 2010 9:57:03 AM GMT Tuesday, November 30, 2010 5:52:46 AM GMT
There are times where the SQL Server and SQL Server Agent Services are running fine post installation but your SQL Server Agent might not start after a restart of your SQL Server and SQL Server Agent services post installation. There may be many causes... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Unable to Shrink/FreeUp TempDB Space - Manjunath's Blog
published 901 days, 14 hours, 8 minutes ago posted by dharadhara 902 days, 17 hours, 31 minutes ago
Tuesday, November 30, 2010 9:57:03 AM GMT Monday, November 29, 2010 6:34:42 AM GMT
Sometimes we come across situation where in the Entire Space in TempDB will be unallocated space but we are unable to free up space neither we are able to shrink the database or file. This was how I was able to Free Up the unallocated space and it worked... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Enabling CDC while Restoring Database
published 910 days, 4 hours, 43 minutes ago posted by dharadhara 911 days, 18 hours, 8 minutes ago
Sunday, November 21, 2010 7:22:41 PM GMT Saturday, November 20, 2010 5:57:31 AM GMT
Restore the Source Database to Destination Database with parameter KEEPCDC. Only “KEEPCDC” needs to be included in “WITH” Option while restoring database. Ex: WITH KEEP_CDC The above process will only work if the Source Database is CDC enabled and CDC... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, cdc
7
Shouts
spam Shout it Mute it

How to search a string value in all columns in the table and in all tables in the database
published 913 days, 5 hours, 36 minutes ago posted by dharadhara 913 days, 17 hours, 50 minutes ago
Thursday, November 18, 2010 6:29:45 PM GMT Thursday, November 18, 2010 6:15:11 AM GMT
One of the common questions I encounter in the different SQL related forums is "How to search all columns in all tables in the database". My usual answer is to refer people to the Question #2 in this blog The ten most asked SQL Server questions... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

COUNT_BIG function - counting very big resultsets - Madhivanan's TSQL Blog
published 914 days, 22 hours, 16 minutes ago posted by dharadhara 915 days, 17 hours, 56 minutes ago
Wednesday, November 17, 2010 1:49:00 AM GMT Tuesday, November 16, 2010 6:09:36 AM GMT
If you want to count the number that exceeds the maximum value of INT datatype, you can make use of COUNTBIG function. COUNTBIG function always returns a bingint datatype value. Consider the following example code which uses both COUNT_BIG and COUNT... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Find Index’s Table Name
posted by dharadhara 918 days, 18 hours, 13 minutes ago
Saturday, November 13, 2010 5:52:15 AM GMT
Hello!!.. At times i came across situations when i need to search for particular index name and on which table it is and for which database. To help me out i came across with this small piece of code yet very useful. So posting it out thought might help... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Open a report in Report Builder from URL
published 919 days, 15 hours, 20 minutes ago posted by dharadhara 920 days, 17 hours, 29 minutes ago
Friday, November 12, 2010 8:45:46 AM GMT Thursday, November 11, 2010 6:35:57 AM GMT
As per this MDN link, we can start report builder by typing URL in browser. Suppose, we can open Report Builder 1.0 from URL by following URL http://localhost:8080/ReportServer/reportbuilder/reportbuilder.application This way we can also open Report Builder... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

What is WebMatrix ?
published 927 days, 1 hour, 48 minutes ago posted by dharadhara 927 days, 17 hours, 4 minutes ago
Thursday, November 04, 2010 10:17:02 PM GMT Thursday, November 04, 2010 7:01:27 AM GMT
This article will give you insight about the WebMatrix. Starting from downloading the tool to install it and creating a web site to deploying it; everything is covered with detail. This will help a developer to get started using WebMatrix to develop a... (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
Previous 1 2 3 4 5 6 7 8 9 10 11 Next