dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 424 days, 1 hour, 56 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
9
Shouts
spam Shout it Mute it

How to use ExportSqlCE to migrate from SQL Server to SQL Compacts
published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1034 days, 21 hours, 58 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Friday, August 20, 2010 9:27:36 AM GMT
Release 2.5 of the SQL Compact schema and data script utility Codeplex project contains a new command line utility, named Export2SqlCe, that allows you to export schema and data from a SQL Server 2005/2008 database in a SQL Compact compatible SQL format. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server Compact, SQL Server
11
Shouts
spam Shout it Mute it

VS 2010 Database Project and Page Verify SQL setting
published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1035 days, 2 hours, 4 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Friday, August 20, 2010 5:20:55 AM GMT
When we create a new database using SSMS, by default Page Verify Option for database is set to CHECKSUM, which is a recommended option and it helps detecting corruption. This setting is used to discover and report incomplete I/O transactions caused by disk I/O errors. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, DBA
10
Shouts
spam Shout it Mute it

SQL Server - Writing IF-ELSE code in TSQL
published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1035 days, 21 hours, 45 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Thursday, August 19, 2010 9:40:36 AM GMT
This article intends to help the beginners to get started with Transact SQL code that uses IF-ELSE logic. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL
7
Shouts
spam Shout it Mute it

SQL Server Performance Monitoring and Alerts using Quest SpotLight - SQL Server Tools In My Environment
published 1036 days, 16 hours, 53 minutes ago posted by jacobsebastianjacobsebastian 1036 days, 22 hours, 16 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Wednesday, August 18, 2010 9:09:13 AM GMT
Keeping a watch on the SQL Server instances, databases and ensuring their health is one of the fundamental responsibility of a DBA. In this post, Malathi Mahadeven explains how Quest SpotLight is used in her environment for SQL Server monitoring and alerting. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: Performance, SQLServer, Tools, Quest Software
12
Shouts
spam Shout it Mute it

Hosting a WCF REST Service with WebServiceHost - Debug Mode
published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1036 days, 2 hours, 20 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Thursday, August 19, 2010 5:05:13 AM GMT
WebServiceHost factory helps us to host a WCF REST Service in managed application. This class is derived from ServiceHost class and automatically enables webHttpBinding and webHttpBehavior on the service End points (more)
category: Web Dev | clicked: 7 | comment | | source: beyondrelational.com
tags: ASP .NET, dot net
9
Shouts
spam Shout it Mute it

How to fix SQL Server Row Size Limit issue
published 1036 days, 16 hours, 53 minutes ago posted by dharadhara 1037 days, 22 hours, 34 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Tuesday, August 17, 2010 8:50:54 AM GMT
QL Server throws error of “Cannot create a row of size 8180 which is greater than the allowable maximum row size of 8060” in Insert/Update statements, This means your SQL statement having fields which are LOB data types and exceeds the limit of row size which is 8086 bytes for physical data store in database how ever It does not have issue with Text and Images as they are stored separately. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: DBA, TSQL
12
Shouts
spam Shout it Mute it

VS2010 Parallel Tasks - Debugging enhancement in VS2010 - Hima's blog
published 1037 days, 15 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1040 days, 35 minutes ago
Tuesday, August 17, 2010 4:21:41 PM GMT Sunday, August 15, 2010 6:50:43 AM GMT
VS2010 has new concept for Parallel Programming that is added as part of .NET Framework 4.0. This makes the ability to work in multi-core processor Environment. Digging through the code and debugging in parallel programming would definitely help. (more)
category: Web Dev | clicked: 0 | 2 comments | | source: beyondrelational.com
tags: VS, Debugging, Visual Studio 2010, paralle programming, Visual Studio
10
Shouts
spam Shout it Mute it

SQL Server - The power of @@rowcount, and the pit falls, if you do not use them correctly! - Madhivanan's TSQL Blog
published 1036 days, 16 hours, 53 minutes ago posted by dharadhara 1039 days, 1 hour, 25 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Monday, August 16, 2010 6:00:49 AM GMT
It is very easy to embed a serious bug in your TSQL code by incorrectly using the @@rowcount function. This post demonstrates the correct way of using it.... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, ROWCOUNT
9
Shouts
spam Shout it Mute it

SQL Server NULLIF() function - Understand how it works internally, or you might get unexpected results. - Dave Ballantyne's Blog
posted by dharadhara 1040 days, 21 hours, 5 minutes ago
Saturday, August 14, 2010 10:20:29 AM GMT
While the SQL Server NULLIF() function is very handy in many cases, there are a few things you need to keep in mind while using this function. This posts presents some of those scenarios where you might find unexpected results. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: DBA, TSQL
Previous 1 2 ... 34 35 36 37 38 39 40 41 42 43 Next