dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 392 days, 4 hours, 49 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

DBCC DBINFO WTIH TABLERESULTS - In which SQL Server version was this database created?
published 571 days, 10 hours, 56 minutes ago posted by dharadhara 573 days, 2 hours, 44 minutes ago
Tuesday, October 25, 2011 11:22:55 PM GMT Monday, October 24, 2011 7:34:56 AM GMT
If you work for a product based organization, you would know that databases created in versions as old as SQL 7 are still around. The only thing is that over time, they have evolved via upgrade programs which have upgraded them to the latest and greatest... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, DBCC
6
Shouts
spam Shout it Mute it

NuGet with multiple projects part-2
published 571 days, 10 hours, 56 minutes ago posted by dharadhara 573 days, 2 hours, 44 minutes ago
Tuesday, October 25, 2011 11:22:55 PM GMT Monday, October 24, 2011 7:34:22 AM GMT
Before some days I have posted one post about how we can add NuGet package other than start project. In this post I am going to explain another way of doing that. Earlier we have use ‘Manage NuGet Package’. Today I am going to use Package Manager Console... (more)
category: Web Dev | clicked: 18 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
6
Shouts
spam Shout it Mute it

Table Scan vs Table Seek
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 576 days, 57 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Friday, October 21, 2011 9:21:24 AM GMT
As we know Indexing is most important point at performance context but here I am going to discuss something which should keep in mind for performance. Following is very simple concept of RDBMS. Table seek is good for large tables (large No. of rows) but... (more)
category: Data | clicked: 22 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Multithreading Concept using .Net - Part III
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 576 days, 57 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Friday, October 21, 2011 9:21:02 AM GMT
Uses of Threads Foreground and Background Threads By default threads are foreground and if application is trying to close and if any foreground thread is running then application will close only after closing of all foreground threads, while background... (more)
category: Web Dev | clicked: 16 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
5
Shouts
spam Shout it Mute it

Changing SQL Server Service Account or Password – Avoid restarting SQL Server
posted by dharadhara 576 days, 1 hour, 2 minutes ago
Friday, October 21, 2011 9:16:29 AM GMT
For anyone who has run Microsoft SQL Server under a domain account, the first thing that comes to mind upon thinking about changing the account or the account password is planning for downtime. However, starting Microsoft SQL Server 2008, this does not... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
3
Shouts
spam Shout it Mute it

WCF # 6 – Create a CLIENT for a WCF Web service(Creating/Implementing a Client for a WCF Service using Configuration files)
posted by dharadhara 577 days, 3 hours, 18 minutes ago
Thursday, October 20, 2011 7:00:15 AM GMT
Hi Geeks, In last post Implementing WCF service in code we saw how to create a client using c# code. Today we will see how to create a client using Configuration files which is quite simpler than writing in a code. * For ease of developers WCF provides... (more)
category: Web Dev | clicked: 1 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
3
Shouts
spam Shout it Mute it

Back To Basics - Update Statement in SQL Server
posted by dharadhara 577 days, 3 hours, 19 minutes ago
Thursday, October 20, 2011 6:59:46 AM GMT
All of us know the basic statement of SQL as insert/update/delete. And am sure of one thing Insert is for inserting the data and delete is for deleting the data.Both are in-place operation. Have you ever thought What is an Update in SQL server? - Is it... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
3
Shouts
spam Shout it Mute it

Index usage
posted by dharadhara 577 days, 3 hours, 19 minutes ago
Thursday, October 20, 2011 6:59:24 AM GMT
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided by SQL Server. This week I will show another one that can be used to see how often a given index has been used. The DMV is this one... (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
11
Shouts
spam Shout it Mute it

SQL SERVER – A Simple Quiz – T-SQL Brain Trick « Journey to SQLAuthority
published 572 days, 22 hours, 26 minutes ago posted by pinaldavepinaldave 578 days, 2 hours, 2 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Wednesday, October 19, 2011 8:16:29 AM GMT
Today we are going to have very simple and interesting question. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines. SELECT MAX(OBJECT_ID) FROM sys.objects SELECT MIN(OBJECT_ID) FROM sys.objects SELECT COUNT(OBJECT_ID) FROM sys.objects Now when you execute individual lines only it will give you error asMsg 2812, Level 16, State 62, Line 1 Could no... (more)
category: Data | clicked: 51 | 2 comments | | source: blog.sqlauthority.com
7
Shouts
spam Shout it Mute it

Want to browse the web faster?
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 578 days, 2 hours, 45 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Wednesday, October 19, 2011 7:33:28 AM GMT
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for an answer to a problem, reading our favorite blogs, checking LinkedIn, or using a web application, it’s used so much that increasing... (more)
category: Data | clicked: 27 | 1 comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

Day 20: WM_Concat Function in Oracle
published 576 days, 4 hours, 25 minutes ago posted by dharadhara 578 days, 2 hours, 45 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Wednesday, October 19, 2011 7:33:05 AM GMT
Let Us Learn Oracle - Part 20 of N [ WM_Concat Function in Oracle ] Source table: tblDept/tblEmployee Purpose: This function is use for string aggregation.It puts a comma between each value it concatenates. But the problem with this function is that it... (more)
category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

TSQL to get All Primary Key Columns and its relevant details
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 578 days, 2 hours, 46 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Wednesday, October 19, 2011 7:32:29 AM GMT
I was working on database design stuff and came across a situation where in i had to get all the primary keys existing in database for all tables and the primary key columns and column details. It would be very had and insane to go into each table and... (more)
category: Data | clicked: 14 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Error encountered in SQL Server - "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"
published 576 days, 4 hours, 25 minutes ago posted by dharadhara 579 days, 2 hours, 42 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 18, 2011 7:36:09 AM GMT
During development of stored procedures, i ran into one issue and this was due to not applied best practice of stored procedures practice and this issue comes mostly when we call stored procedures inside another one and so on, which are used in nested... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

TSQL Challenge 66 - Find the most relevant advertisement based on keywords
published 576 days, 4 hours, 25 minutes ago posted by dharadhara 579 days, 2 hours, 43 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 18, 2011 7:35:45 AM GMT
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, Puzzle, TSQL
7
Shouts
spam Shout it Mute it

DBCC DROPCLEANBUFFERS needs to be preceded by a CHECKPOINT to remove all buffers
published 576 days, 4 hours, 25 minutes ago posted by dharadhara 579 days, 2 hours, 43 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 18, 2011 7:35:11 AM GMT
DBCC DROPCLEANBUFFERS is a very familiar DBCC command in use during performance tuning exercises. We have always used it to test queries with a cold buffer cache without shutting down and restarting the server. But, did you know that DBCC DROPCLEANBUFFERS... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Day 18: Date functions in Oracle
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 580 days, 4 hours, 21 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Monday, October 17, 2011 5:56:57 AM GMT
Let Us Learn Oracle - Part 18 of N [ Date functions in Oracle ] Source table: tblPlayers Oracle has a rich set of Date functions about which we will see under Get Current Date For getting current date we can use Sysdate or Current_Date SQL> Select... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Oracle
8
Shouts
spam Shout it Mute it

JQGrid methods
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 580 days, 4 hours, 23 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Monday, October 17, 2011 5:55:55 AM GMT
I am listing here some useful methods of JqGrid (Jquery data grid plugin). you can read more about JqGrid here . You can also see demo of this grid here . Html tag to declare JqGrid on web page (more)
category: Web Dev | clicked: 43 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
7
Shouts
spam Shout it Mute it

SSIS #101 – Use expressions to pass parameters to ADO.NET Source
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 580 days, 4 hours, 23 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Monday, October 17, 2011 5:55:26 AM GMT
I have several posts on how to pass parameters to 1) an OLE DB source in a data flow and 2) to an Execute SQL Task with OLE DB connection. For case 2), the key is to use the correct mark for the passed in parameter. Different connection types demand different... (more)
category: Data | clicked: 22 | 1 comment | | source: beyondrelational.com
tags: SQL Server, ADO.NET, SSIS
7
Shouts
spam Shout it Mute it

Microsoft SQL Server Reference Architecture and Appliances
published 572 days, 22 hours, 26 minutes ago posted by dharadhara 582 days, 16 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Saturday, October 15, 2011 10:02:30 AM GMT
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured... (more)
category: Data | clicked: 21 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Microsoft
6
Shouts
spam Shout it Mute it

Day 16: Greatest and Least function in Oracle
published 576 days, 4 hours, 25 minutes ago posted by dharadhara 582 days, 17 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Saturday, October 15, 2011 10:01:48 AM GMT
Let Us Learn Oracle - Part 16 of N [ Greatest and Least function in Oracle ] Source table: tblStudents Purpose: Finds the Greatest and the Least number from a range of numbers Example of Greatest function SQL> Select Greatest(10,20,4,56,234,999,12... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, Oracle
Previous 1 2 ... 4 5 6 7 8 9 10 11 12 13 ... 42 43 Next