DotNetShoutout

SQL

2
Shouts

Shout it

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

posted by

eralper 1031 days, 19 hours, 8 minutes ago

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure If you are planning to use OpenRowset queries in order to connet to remote database servers or if you have already implemented OpenRowset queries as a solution to remote connections as an alternative tp linked servers in Microsoft SQL Server 2005, you should first configure the database instance to enable Ad Hoc Distributed Queries in the installed SQL Server database instance where the Ad Hoc query will run. There are two ... (more)

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

| flag as spam

tags: SqlServer 2008, SQL, SQLServer, sp_configure, Ad hoc

4
Shouts

Shout it

Introduction of the Cursors in SQL Server

published 1032 days, 17 hours, 53 minutes ago posted by

codegain 1033 days, 18 hours, 19 minutes ago

Stored procedures are stored in SQL Server databases. The simplest implication of stored procedures is to save complicated queries to the database and call them by name, so that users won’t have to enter (more)

category: Data | clicked: 0 | comment | | source: codegain.com

tags: SQL Server, cursors, SQL, Stored Procedure

5
Shouts

Shout it

Scott Hanselman - Simple Code First with Entity Framework 4 - Magic Unicorn Feature CTP 4

published 1037 days, 20 hours, 42 minutes ago posted by

raju 1039 days, 1 hour, 33 minutes ago

Microsoft's been releasing a number of right-sized LEGO pieces lately. In case you missed it, Betas have been announced for:SQL 4 Compact Edition - It has a small embedded file-based SQL Database, and a web-server called IIS Express that's compatible with the full version of IIS. "Razor" Page Syntax- A way to make pages/ViewEngine called "Razor." Your sites can be later be expanded to use all of ASP.NET MVC. It's a simple syntax that is easy to learn. WebMatrix - It's a small (15 megs if you have .NET 4,... (more)

category: Web Dev | clicked: 2 | comment | | source: www.hanselman.com

tags: ASP.NET MVC, .net 4, Framework4.0, SQL, Razor, IIS Express

7
Shouts

Shout it

The Self Join – Inner Join and Outer Join - An Example

published 1043 days, 19 hours, 29 minutes ago posted by

pinaldave 1044 days, 2 hours, 14 minutes ago

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

Increase Database Performance with Proper Indexing (A Practical Experience Explained)

published 1045 days, 19 hours, 44 minutes ago posted by

http://uniquesaiful.blogspot.com/ 1047 days, 3 hours, 43 minutes ago

Increase database performance with proper indexing (A practical experience explained) Relational databases used index to find out data quickly. An Index is an underlying structure that determines how data is stored. Proper Indexing can increase your database’s overall performance when your database becomes larger. Recently I have worked with a medical customer who uses software for their Pathology department developed by other party. Problem with that software was that it becomes slower by the end of ... (more)

category: Data | clicked: 0 | comment | | source: webupon.com

tags: SQL, Performance, index

6
Shouts

Shout it

Validating an SQL query programmatically, with gotcha | AdaTheDev

published 1047 days, 3 minutes ago posted by

AdaTheDev 1048 days, 2 hours, 2 minutes ago

A run through of how to validate an SQL query programmatically, but with a gotcha. (more)

category: Data | clicked: 4 | comment | | source: www.adathedev.co.uk

tags: SQL Server, SQL

8
Shouts

Shout it

LINQ Group By with NULL database values

published 1047 days, 18 hours, 38 minutes ago posted by

http://vistadb.myopenid.com/ 1048 days, 17 hours, 27 minutes ago

LINQ is fantastic for the ability to write queries that express intent much more clearly than the same SQL, or structured code. One problem that I have run into though is handling NULL database values that are part of a group by statement. Grouping by ProductSKU Grouping in LINQ allows you to return sets of data from a collection for a given key value. The group by clause is what the key ends up being in the result set. Lets take a grouping of the Products by the SKU.from p in Products group p ... (more)

category: Data | clicked: 41 | comment | | source: infinitecodex.com

tags: VistaDB, SQL, Group by, Linq

5
Shouts

Shout it

Daily tech links for .net and related technologies - June 5-7, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1049 days, 44 minutes ago

Workshop Planning Framework – The Six P’s - J.D. Meier , Outsourcing Doesn’t Work - Amber , 10 Things I Learned In Web School - Luke Wroblewski , The Cure for Creative Blocks? Leave Your Desk. - Jocelyn K. Glei , Client Rejection – Why No Means Nothing - Chandler Quintin , Extreme LINQ, building a RayTracer - Coding4Fun , What is a PM? - J.D. Meier , .NET Enumerated Types Explained - B. James (more)

category: Web Dev | clicked: 1 | comment | | source: weblogs.asp.net

| flag as spam

tags: Silverlight, SQL, Web Service, Architecture

7
Shouts

Shout it

EntitySpaces ORM 2010 Official Release

published 1049 days, 18 hours, 41 minutes ago posted by

MikeGriffin 1051 days, 18 hours, 59 minutes ago

We are pleased to announce the release of EntitySpaces 2010. We have excellent WCF and Silverlight support and much more ... Microsoft SQL Server / SQL CE, Microsoft Access, Oracle, MySQL, VistaDB, PostgreSQL, Sybase SQL Anywhere, SQLite http://www.entityspaces.net (more)

category: Metro | clicked: 2 | comment | | source: www.entityspaces.net

tags: Silverlight, Sybase, SQL, SQLite, Oracle, Architecture, WCF, ORM

5
Shouts

Shout it

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

published 1052 days, 18 hours, 40 minutes ago posted by

pinaldave 1053 days, 7 hours, 18 minutes ago

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed below. You will be successfully able to test multiple instances of SQL Server using this tool. Once the tool is launched, select the product you wish to analysis. Click on Start Scan will take few minut... (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Daily tech links for .net and related technologies - June 28-30, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1055 days, 20 hours, 35 minutes ago

Web Application Extensibility with FubuMVC (Part 2) - Jeremy D. Miller, Using ASP.NET's ActionResult to Abstract Dependencies - Jeffrey Palermo, Checking Client Download Success with ASP.NET MVC - OdeToCod,e , Default Encoding of Strings in ASP.NET MVC 2 - Steve, Online Payments Using PayPal- Integration with ASP.NET - BangaruBabu, Planning your E-Commerce Website - Jacob Gube, The Complete Web Design Style Series (700 Designs in 14 Categories) - apaulandrew, 40 Creative 404 Error Pages to Insp... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

| flag as spam

tags: Silverlight, SQL, Web Service, Architecture, Ajax

6
Shouts

Shout it

Statistics without Index - Possible and Helpful

published 1054 days, 19 hours, 39 minutes ago posted by

pinaldave 1056 days, 6 hours, 27 minutes ago

A Simple note about the subject, how statistics can be helpful and how they are created. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Compiling LINQ queries for improved performance

published 1059 days, 23 hours, 11 minutes ago posted by

deanomachino 1061 days, 17 hours, 6 minutes ago

Compiling LINQ queries for improved performance I've been using Linq to Sql for quite a while now, and here and there I have heard of compiling your Linq queries mentioned. Now I know that this feature has been around for a while in terms of .net, but I have never actually got round to using it. I started to look into it and found out that it is actually really easy, and it really does improve the performance of your query. So this is how you would write a standard linq query: But if we wante... (more)

category: Data | clicked: 0 | comment | | source: www.deanhume.com

tags: 3.5, C#, SQL, Performance, Improve Performance, Linq

5
Shouts

Shout it

Find Data Stored in SQL Server Cache

published 1062 days, 18 hours, 49 minutes ago posted by

pinaldave 1063 days, 8 hours, 20 minutes ago

A Common Question: Can I see what data is cached in my SQL Server Memory? A Simple Answer: Yes. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

Shrink, MDF, NDF and Reader's Opinion - What's Yours?

published 1066 days, 19 hours, 41 minutes ago posted by

pinaldave 1069 days, 36 minutes ago

Blog Reader and SQL Expert Imran has wonderful explanation of how Shrinking, MDF and NDF works. What is your opinion? (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider - Dixin's Blog

published 1072 days, 22 hours, 59 minutes ago posted by

jrspinella 1073 days, 16 hours, 57 minutes ago

[LINQ via C# series] So far LINQ to SQL data CRUD (Creating / Retrieving / Updating / Deleting) has been explained. This post takes a deeper look at the internal implementation of LINQ to SQL query.The provider model Unlike IEnumerable / IEnumerable (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

tags: SQL, Linq

5
Shouts

Shout it

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

published 1074 days, 20 minutes ago posted by

pinaldave 1075 days, 5 hours, 24 minutes ago

A few days ago, I received following email: “Pinal, We are in an emergency situation. We have a large database of around 80+ GB and its backup is of 50+ GB in size. We need to restore this database ASAP and use it; however, restoring the database takes forever. Do you think a compressed backup would solve our problem? Any other ideas you got?” First of all, the asker has already answered his own question. Yes; I have seen that if you are using a compressed backup, it takes lesser time when you try to ... (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

Daily tech links for .net and related technologies - June 8-11, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1075 days, 22 hours ago

Code Contracts Part 5 - Abstract Types and Interfaces - Kevin Hazzard , DRY your CruiseControl.NET Configuration - Geoff Lane , A ToDynamic() Extension Method For Fluent Reflection - Dixin , Debugging .NET 2.0 Assembly from unmanaged Code in VS2010? - Rick Strahl , How To Spot A Sketchy Client (Plus A Contract Template) - Speider Schneider , 6 important uses of Delegates and Events - Questpond , The Best Code You Will Ever Write - John Sonmez , Comparing .Net IoC containers, part seven: MEF - A... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

| flag as spam

tags: Silverlight, SQL, Web Service, Architecture, Ajax

5
Shouts

Shout it

Building a Dynamic LINQ to Entities Compiler (Part 1)

posted by

http://vistadb.myopenid.com/ 1076 days, 3 hours, 25 minutes ago

In this article I will explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework. Due to the wide range of technologies used this article, it will be broken up into two parts as listed below. We are working on a dynamic linq query mechanism for the next major release of VistaDB. Our goal is to provide a LinqPad type of environment in Data Builder for users to write LINQ queries against the database without having to first build an EF m... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

| flag as spam

tags: SQL Server, Entity Framework, VistaDB, SQL, Linq

10
Shouts

Shout it

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

published 1078 days, 21 hours, 34 minutes ago posted by

pinaldave 1081 days, 7 hours, 58 minutes ago

Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

Welcome!

SQL

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

Introduction of the Cursors in SQL Server

Scott Hanselman - Simple Code First with Entity Framework 4 - Magic Unicorn Feature CTP 4

The Self Join – Inner Join and Outer Join - An Example

Increase Database Performance with Proper Indexing (A Practical Experience Explained)

Validating an SQL query programmatically, with gotcha | AdaTheDev

LINQ Group By with NULL database values

Daily tech links for .net and related technologies - June 5-7, 2010 - Sanjeev Agarwal

EntitySpaces ORM 2010 Official Release

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

Daily tech links for .net and related technologies - June 28-30, 2010 - Sanjeev Agarwal

Statistics without Index - Possible and Helpful

Compiling LINQ queries for improved performance

Find Data Stored in SQL Server Cache

Shrink, MDF, NDF and Reader's Opinion - What's Yours?

Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider - Dixin's Blog

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

Daily tech links for .net and related technologies - June 8-11, 2010 - Sanjeev Agarwal

Building a Dynamic LINQ to Entities Compiler (Part 1)

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

Open ID Login

Standard Login

Forgot Password?

Sign up