DotNetShoutout

SQL

2
Shouts

Shout it

Check whether an expression is numeric type in sql server - Dot Net logiX

posted by

DotNetLogix 940 days, 14 hours, 17 minutes ago

Check whether an expression is numeric type in sql server - Dot Net logiX (more)

category: Data | clicked: 1 | comment | | source: www.dotnetlogix.com

| flag as spam

tags: sql 2005, SQL 2008, SQL

8
Shouts

Shout it

A Feature-driven Comparison of Entity Framework and NHibernate—Fetch Plans

published 941 days, 2 hours, 32 minutes ago posted by

sonukapoor 943 days, 9 hours, 49 minutes ago

This article is about fetch plans-a recognized and common way for developers to instruct the O/RM about the structure of the SQL you desire. (more)

category: Architecture | clicked: 2 | comment | | source: dotnetslackers.com

tags: SQL, NHibernate, fetch-plan, ORM

12
Shouts

Shout it

Known Unknown of System Stored Procedure of sys.sp_tables

published 943 days, 8 hours, 47 minutes ago posted by

pinaldave 944 days, 6 hours, 33 minutes ago

http://blog.sqlauthority.com/2010/10/17/sql-server-system-stored-procedure-sys-sp_tables/ (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Use sequential guids in c# « Daniel Wertheim

published 945 days, 9 hours, 9 minutes ago posted by

sedanwer 947 days, 4 hours, 35 minutes ago

Use sequential guids in c# 2010/10/14by Daniel WertheimLeave a Comment Sql-server has support for generating sequential ids so that they get indexed in a ordered fashion. .Net doesn’t have this. You could invoke code in a managed library but that will not guarantee uniqueness if the computer has mac….. yada, yada, yada.. Why not let Sql-server generate a batch, sit on them in .Net in a queue and when needed you check one out? I’m not saying you should. I’m saying you could. (more)

category: Data | clicked: 3 | comment | | source: daniel.wertheim.se

tags: ADO.NET, sequential guids, SQL

4
Shouts

Shout it

Kodyaz Development Resources

published 948 days, 4 hours, 51 minutes ago posted by

eralper 949 days, 10 hours, 21 minutes ago

Problem Statement: In your SQL Server database you have two database tables to store expenses and payments for closing expense amount. You want to list the expenses of a customer using t-sql by querying your sql tables. This list will also add the payments done by the same customer to close these expenses. Each payment will be listed as new columns beside the expenses records. (more)

category: Data | clicked: 1 | comment | | source: www.kodyaz.com

tags: SQL Server, CTE, SQL Server 2008, SQL, T-SQL, SQL Server 2005

10
Shouts

Shout it

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

published 949 days, 8 hours, 55 minutes ago posted by

pinaldave 949 days, 20 hours, 21 minutes ago

If you are using Encrypted Stored Procedure you not see them in Activity Monitor (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

SQL Server Transact-SQL (SSQA.net) : How to Generate Script along with Data?

published 954 days, 8 hours, 54 minutes ago posted by

eralper 956 days, 11 hours, 34 minutes ago

How to Generate Script along with Data? One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data SQL Server 2008 http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx SQL Server 2000/2005 http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en Publishe... (more)

category: Data | clicked: 0 | comment | | source: sqlserver-qa.net

tags: SQL Server, SQL, script

4
Shouts

Shout it

Raymond Camden's ColdFusion Blog: Exporting SQL Server Data to a Script

published 954 days, 8 hours, 46 minutes ago posted by

eralper 956 days, 11 hours, 43 minutes ago

Exporting SQL Server Data to a Script So, I recently ran into an interesting problem. I needed to export data from SQL Server, but I need it in a form that I could use in a script - in other words, I wanted to export to a series of insert statements. Unfortunately, SQL Server (specifically Enterprise Manager, and I should be clear that I use both terms off and on to refer to the same thing) only lets you export to a delimited file - not a file you can run as is. (Unlike mySQL-Front, a darn nice client f... (more)

category: Data | clicked: 2 | comment | | source: www.coldfusionjedi.com

tags: SQL Server, SQL, script

4
Shouts

Shout it

SQL Server Manager select and kill process query

published 954 days, 8 hours, 46 minutes ago posted by

eralper 956 days, 11 hours, 56 minutes ago

Who is hogging the database process? This question can be hard to answer if you don’t have the right tools to view the Activity monitor. (more)

category: Data | clicked: 0 | comment | | source: www.ninjacoding.net

tags: SQL, T-SQL, SQLServer

14
Shouts

Shout it

The Limitations of the Views – Eleven and more…

published 956 days, 11 hours, 57 minutes ago posted by

pinaldave 958 days, 13 hours, 51 minutes ago

I am confident that you may know few and you may know many. I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

SQL Server 2008 SP2 is available for download today! - SQL Server Team Blog

published 959 days, 2 hours, 57 minutes ago posted by

iftekharahmedamit 961 days, 17 hours, 36 minutes ago

Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center. Service Pack 2 for SQL Server 2008 includes new compatibility features with SQL Server 2008 R2, product improvements based on requests from the SQL Server community, and hotfix solutions provided in SQL Server 2008 SP1 Cumulative Update 1 to 8. Key improvements in Microsoft SQL Server 2008 Service Pack 2 are:.. (more)

category: Data | clicked: 0 | comment | | source: blogs.technet.com

tags: SQL Server, SQL Server 2008, SQL, SP2, SQL Server 2008 SP2

12
Shouts

Shout it

Wait Stats and Health Check - A Path to Performance

published 961 days, 18 hours, 28 minutes ago posted by

pinaldave 962 days, 20 hours, 6 minutes ago

Wait Stat Analysis is very crucial for optimizing databases, but it is often overlooked due to lack of understanding. We perform advanced resource Wait Statistics Analysis and provide you with suggestions to optimize your database server. We train your DBA to make them skillful enough so they can perform this analysis by themselves in the future. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

Things good to know about SQL State Server

published 967 days, 15 hours, 28 minutes ago posted by

http://jclaes.blogspot.com/ 968 days, 4 hours, 7 minutes ago

While installing a SQL State Server last week, I came across a few things worth sharing about the installation and use of SQL State Server. (more)

category: Web Dev | clicked: 1 | comment | | source: jclaes.blogspot.com

tags: SQL, state, ASP.NET, Session

11
Shouts

Shout it

SQL SERVER – COUNT() Not Allowed but COUNT_BIG() Allowed – Limitation of the View 5 « Journey to SQL Authority with Pinal Dave

published 967 days, 15 hours, 28 minutes ago posted by

pinaldave 968 days, 11 hours, 59 minutes ago

One of the most prominent limitations of the View it is that it does not support COUNT(); however, it can support COUNT_BIG() operator. In the following case, you see that if View has COUNT () in it already, it cannot have a clustered index on it. On the other hand, a similar index would be created if we change the COUNT () to COUNT_BIG (*).For an easier understanding of this topic, let us see the example here. USE tempdb GO IF EXISTS (SELECT * FROM sys.views WHERE OBJECTID = OBJECTID(N'[dbo].[... (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

SQL Server Compact Toolbox – Extension #12 - Sara Ford

published 964 days, 11 hours, 32 minutes ago posted by

jantu 969 days, 3 hours, 54 minutes ago

If you use SQL Server Compact, Microsoft’s embedded database for devices, desktops and soon ASP.NET, this extension is for you. It adds several features not found in Server Explorer Data Connections: * Support for both version 3.5 and 4.0 database files * Script tables, including data * Script entire schema, optionally with data, both of SQL Server Compact and SQL Server 2005 or later databases (more)

category: How To | clicked: 0 | comment | | source: blogs.msdn.com

tags: extensions, SQL, ASP .NET

16
Shouts

Shout it

How to Stop Growing Log File Too Big

published 970 days, 11 hours, 16 minutes ago posted by

pinaldave 971 days, 15 hours, 18 minutes ago

A Simple Solution to Ancient Problem (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

15
Shouts

Shout it

What is an MVP? – How to become an MVP?

published 973 days, 10 hours, 6 minutes ago posted by

pinaldave 975 days, 15 hours, 46 minutes ago

A Direct Answer to Famous Question! (more)

category: Web Dev | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

12
Shouts

Shout it

Gibraltar Software Acquires VistaDB

published 971 days, 10 hours, 52 minutes ago posted by

http://vistadb.myopenid.com/ 976 days, 16 hours, 35 minutes ago

VistaDB, an Embedded SQL Database Engine Used By Thousands of .NET Developers Worldwide, Has Been Acquired By Esymmetrix, Developer of Gibraltar Software, a Suite of Products for Application Monitoring and Customer Support. – Read full press releaseWelcome the new team Please welcome Gibraltar Software as the new team that will drive VistaDB forward. Kendall and the entire Gibraltar team know the product very well, they use it in their own products. Very similar to how I took over VistaDB originally, ... (more)

category: Data | clicked: 26 | 1 comment | | source: infinitecodex.com

tags: VistaDB, SQL

2
Shouts

Shout it

enable disable trick with bit data type in sql | eugene.K

posted by

eugeneK 977 days, 9 hours, 57 minutes ago

Many times when we design our tables in SQL we create bit value for on/off something ie. activity of item. So if i have a bookstore then each book item in Books table would have “isAvailable” bit column which will tell us if the book is available in stock so users can order it or not. All fine for now but what happens when I want to change availability status? First i would need to have bookID for example to know which book i want to change the status for, then to have current status of t... (more)

category: Data | clicked: 0 | comment | | source: ekdd.co.il

| flag as spam

tags: MSSQL, SQL

7
Shouts

Shout it

Dean Hume - A Simple Guide to SQL Compact 4

published 983 days, 11 hours, 48 minutes ago posted by

deanomachino 984 days, 12 hours, 38 minutes ago

A Simple Guide to SQL Compact 4 There has been quite a lot of interest building up recently around SQL Compact 4. Now, if you are not familiar with SQL compact, it's basically a database engine that is free and totally embedded. You don't need to install a database anywhere on your server. Not only that, but it works with existing .NET based data API's (Entity Framework, NHibernate). Another great advantage of using a SQL CE database is that it is totally file based and you can store your database... (more)

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

tags: C#, SQL, SQL Compact, SQL compact 4

Welcome!

SQL

Check whether an expression is numeric type in sql server - Dot Net logiX

A Feature-driven Comparison of Entity Framework and NHibernate—Fetch Plans

Known Unknown of System Stored Procedure of sys.sp_tables

Use sequential guids in c# « Daniel Wertheim

Kodyaz Development Resources

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

SQL Server Transact-SQL (SSQA.net) : How to Generate Script along with Data?

Raymond Camden's ColdFusion Blog: Exporting SQL Server Data to a Script

SQL Server Manager select and kill process query

The Limitations of the Views – Eleven and more…

SQL Server 2008 SP2 is available for download today! - SQL Server Team Blog

Wait Stats and Health Check - A Path to Performance

Things good to know about SQL State Server

SQL SERVER – COUNT() Not Allowed but COUNT_BIG() Allowed – Limitation of the View 5 « Journey to SQL Authority with Pinal Dave

SQL Server Compact Toolbox – Extension #12 - Sara Ford

How to Stop Growing Log File Too Big

What is an MVP? – How to become an MVP?

Gibraltar Software Acquires VistaDB

enable disable trick with bit data type in sql | eugene.K

Dean Hume - A Simple Guide to SQL Compact 4

Open ID Login

Standard Login

Forgot Password?

Sign up