DotNetShoutout - Stories tagged with SQL

SQL

atom rss
5
Shouts
spam Shout it Mute it

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint « Journey to SQL Authority with Pinal Dave
published 1191 days, 14 hours, 16 minutes ago posted by pinaldavepinaldave 1191 days, 18 hours, 54 minutes ago
Tuesday, March 16, 2010 1:20:20 PM GMT Tuesday, March 16, 2010 8:42:45 AM GMT
Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan? First of all, I am not going to analysis their need of why, in fact, they want to convert seek to scan or use no index here. The requirement is strange as using no index o... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
6
Shouts
spam Shout it Mute it

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU « Journey to SQL Authority with Pinal Dave
published 1191 days, 14 hours, 16 minutes ago posted by pinaldavepinaldave 1191 days, 18 hours, 57 minutes ago
Tuesday, March 16, 2010 1:20:20 PM GMT Tuesday, March 16, 2010 8:39:26 AM GMT
This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single batch. Let us consider the following example of this query. The following query usually runs on multicore on a dual core machine (please note it may not be the case with your machine). USE AdventureWorks GO SELECT * FRO... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

HerdingCode - Episode 75: Barry Dorrans on Developer Security
published 1199 days, 15 hours, 8 minutes ago posted by mithumithu 1201 days, 9 hours, 46 minutes ago
Monday, March 08, 2010 12:28:22 PM GMT Saturday, March 06, 2010 5:50:39 PM GMT
This week on Herding Code, Barry Dorrans educates, entertains, insults and scares us with his expert commentary on application security, threat modeling, analysis tools and common attacks. You’ve been waiting for this show. I just know it. Listen in as Barry talks security, pimps his new book, and comments on his new position at Microsoft, book burnings, guns, money, proper pronunciation and Jon’s bald head. Scott K shares that public facing applications and services seem to get the least attention ... (more)
category: Podcast | clicked: 1 | 2 comments | | source: herdingcode.com
tags: RIA, Silverlight, WebForms, Security, .NET Framework, OAuth, cat.net, OpenID, Flash, SQL, XSS, WPL, FxCop, HerdingCode, WRAP, MVC 2, SDL, Cardspace, MVC, OWASP, ASP.NET
7
Shouts
spam Shout it Mute it

SQL SERVER – Rollback TRUNCATE Command in Transaction « Journey to SQL Authority with Pinal Dave
published 1202 days, 13 hours, 3 minutes ago posted by pinaldavepinaldave 1203 days, 7 hours, 7 minutes ago
Friday, March 05, 2010 2:33:53 PM GMT Thursday, March 04, 2010 8:29:54 PM GMT
This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not. If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not be retrieved from log file. TRUNCATE is DDL operation and it is not logged in log file. Update: (Based on comments of Paul Randal) Truncate IS a logged operation, it just doesn’t log removing the records, ... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
7
Shouts
spam Shout it Mute it

Queue table processing in SQL Server | AdaTheDev
posted by AdaTheDevAdaTheDev 1206 days, 5 hours, 4 minutes ago
Monday, March 01, 2010 10:32:32 PM GMT
The scenario is you queue up records in a database table, each representing a piece of work needing to be done. You then want to have processes that periodically poll this table to pick up the next item of work from the queue and process them. (more)
category: Data | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: SQL, SQLServer
4
Shouts
spam Shout it Mute it

Changing primary key index structure | AdaTheDev
posted by AdaTheDevAdaTheDev 1206 days, 19 hours, 25 minutes ago
Monday, March 01, 2010 8:11:50 AM GMT
Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it. (more)
category: Data | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: indexing, primary key, SQL, SQLServer
4
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - Mar 01-03, 2010 - Sanjeev Agarwal
posted by sanjeevanasanjeevana 1206 days, 20 hours, 42 minutes ago
Monday, March 01, 2010 6:54:16 AM GMT
ASP.NET MVC TempData Extension Methods - Donn, Model Validation & Metadata in ASP.NET MVC 2 - K. Scott Allen, Encrypted Hidden Inputs in ASP.NET MVC - Ashic, SiteMapProvider for Dynamic Data - Steve, Web Forms Routing in ASP.NET 4 - David Hayden, Isolating browser specific code in Javascript: - Mark Needham, Introduction to the Reactive Extensions for JavaScript – Cre... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
| flag as spam
tags: Silverlight, SQL, Web Service, Agile, Architecture, Ajax
6
Shouts
spam Shout it Mute it

Resize Image In Asp.Net And Upload To Databse
posted by amitjainamitjain 1209 days, 7 hours, 18 minutes ago
Friday, February 26, 2010 8:18:10 PM GMT
In this example i am going to describe how to resize image and upload to ms sql database in asp.net. For this i am using FileUpload control to upload the image in datbase after resizing. I am also displaying the Image in Gridviw after uploading to database. (more)
category: Web Dev | clicked: 0 | comment | | source: csharpdotnetfreak.blogspot.com
tags: grid View, SQL, Database, ASP.NET
4
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - Feb 22-24, 2010 - Sanjeev Agarwal
published 1212 days, 21 hours, 37 minutes ago posted by sanjeevanasanjeevana 1213 days, 17 hours, 30 minutes ago
Tuesday, February 23, 2010 6:00:03 AM GMT Monday, February 22, 2010 10:06:13 AM GMT
Partial Validation in ASP.NET MVC 2 - Steve Sanderson, ASP.NET 4.0, Part 5: I’lll Name That Browser In One - Dan Maharry, Manipulating Action Method Parameters - Phil Haack, jQuery Custom Element and Global Events - Sergio Pereira, Making your ASP.NET application work as a service - Al Pascual, Intro to jQuery Materials - G. Andrew Duthie, Web Design25 jQuery Tutorial... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: Silverlight, SQL, Web Service, Agile, Testing, Architecture, Ajax, WCF
3
Shouts
spam Shout it Mute it

Optimising date filtered SQL queries | AdaTheDev
posted by AdaTheDevAdaTheDev 1213 days, 19 hours, 25 minutes ago
Monday, February 22, 2010 8:11:57 AM GMT
How you structure your SQL queries is very important and choosing the wrong approach can have big effects on the performance of the query. This article shows the difference between an optimal query and a sub-optimal query resulting from subtle changes to the approach taken. (more)
category: Data | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: optimisation, SQL, Performance, SQLServer, index
3
Shouts
spam Shout it Mute it

SQL Server 2008 - Table Valued Parameters vs XML vs CSV | AdaTheDev
posted by AdaTheDevAdaTheDev 1213 days, 19 hours, 29 minutes ago
Monday, February 22, 2010 8:07:42 AM GMT
A performance walkthrough of passing a dynamic number of values to an stored procedure using the new table valued parameter support within SQL Server 2008, in comparison with XML and CSV parameter approaches. (more)
category: Data | clicked: 4 | comment | | source: www.adathedev.co.uk
tags: SQL, Performance, SQLServer
7
Shouts
spam Shout it Mute it

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 1217 days, 13 hours, 31 minutes ago posted by pinaldavepinaldave 1217 days, 19 hours, 4 minutes ago
Thursday, February 18, 2010 2:05:33 PM GMT Thursday, February 18, 2010 8:32:20 AM GMT
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, Database, pinaldave, SQLAuthority
5
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - Feb 18-20, 2010 - Sanjeev Agarwal
published 1217 days, 13 hours, 31 minutes ago posted by sanjeevanasanjeevana 1217 days, 20 hours, 21 minutes ago
Thursday, February 18, 2010 2:05:33 PM GMT Thursday, February 18, 2010 7:15:12 AM GMT
Quick Tips About ASP.NET MVC – AJAX-Enabled Partial Views -nuous, ASP.NET MVC – Switch between secure(https or ssl) & unsecure(http) connections - Rajan,Using T4 Templates to Create Strongly Typed View Names - HighOnCoding,ASP.NET MVC 2 Model Validation - MikeLooking, Ahead to ASP.NET 4.0 - K. Scott Allen,Web DesignCreate a Clean and Professional Web Design in P... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: Silverlight, SQL, Web Service, Architecture, Ajax, ASP.NET
4
Shouts
spam Shout it Mute it

DeepFriedBytes - Episode 45: Making Sense of What Was Oslo with Lars Corneliussen
posted by mithumithu 1218 days, 9 hours, 24 minutes ago
Wednesday, February 17, 2010 6:12:53 PM GMT
At PDC 2009 Oslo was renamed to SQL Modeling and it left a lot of developers scratching their heads. What better way to sort it all out than to talk with someone deep into the stack. We sat down with Lars Corneliussen to see how this is all going to turn out and it what it means for developers. Definitely an interesting show as it paints a different picture about where things are going with M, M Grammar, SQL modeling, Entity Framework, Quadrant and so on. (more)
category: Podcast | clicked: 0 | comment | | source: deepfriedbytes.com
tags: SQL, PDC 2009, DeepFriedBytes, SQL modeling
7
Shouts
spam Shout it Mute it

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
published 1224 days, 16 hours, 6 minutes ago posted by pinaldavepinaldave 1225 days, 14 hours, 24 minutes ago
Thursday, February 11, 2010 11:30:56 AM GMT Wednesday, February 10, 2010 1:12:46 PM GMT
I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
3
Shouts
spam Shout it Mute it

Daily tech links for .net and related technologies - Feb 10-12, 2010
posted by sanjeevanasanjeevana 1225 days, 18 hours, 33 minutes ago
Wednesday, February 10, 2010 9:03:07 AM GMT
ASP.NET MVC security checklist, Multi-tenancy in ASP.NET MVC - Views - Rob Ashton, Default Values in ASP.NET MVC Action Parameters - David Hayden, Quick Tips About ASP.NET MVC – UI Helpers and Templates - Nuno Silva, Quick Tips About ASP.NET MVC – Editor Templates - Nuno Silva, ASP.NET MVC Quick Tips – Pass data to your master page -Nuno Silva, ASP.NET MVC Quick Tips – What should my Model be? -Nuno silva, Using the BeginMethod/EndMethod pattern with MVC - Ricka MVC FAQ -Ricka, Using Mi... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: Silverlight, SQL, Web Service, Architecture, Ajax, WCF, ORM
3
Shouts
spam Shout it Mute it

How do I set a breakpoint in a CLR Stored Procedure already deployed and running on a live SQL Server and debug is using Visual Studio? - Jay Askew
published 1227 days, 13 hours, 56 minutes ago posted by impaimpa 1228 days, 16 hours, 19 minutes ago
Monday, February 08, 2010 1:40:11 PM GMT Sunday, February 07, 2010 11:17:44 AM GMT
For information on setup and debugging a CLR stored procedure in a direct-debug scenario by “stepping-through” the code from within Visual Studio, OR by using a test TSQL script from with Visual Studio, refer to the following MSDN article: http://msdn.microsoft.com/en-us/library/ms165051.aspx Now, suppose you have a stored procedure already deployed to a remote SQL S... (more)
category: Web Dev | clicked: 0 | comment | | source: blogs.msdn.com
tags: .NET, CLR, SQL, Debug, Visual Studio
13
Shouts
spam Shout it Mute it

Transact-SQL Delayed Execution
published 1237 days, 17 hours, 1 minute ago posted by BlackWaspBlackWasp 1245 days, 4 hours, 50 minutes ago
Friday, January 29, 2010 10:35:37 AM GMT Thursday, January 21, 2010 10:46:49 PM GMT
Transact-SQL includes the WAITFOR statement. This command allows the execution of a script or procedure to be blocked for a period of up to twenty-four hours. The process can be delayed until a specified time or for a number of hours, minutes and seconds. (more)
category: Data | clicked: 0 | comment | | source: www.blackwasp.co.uk
tags: SQL Server, SQL
2
Shouts
spam Shout it Mute it

No process is on the other end of the pipe Sql Server Shared Memory Provider error 233
posted by amitjainamitjain 1245 days, 19 hours, 4 minutes ago
Thursday, January 21, 2010 8:32:16 AM GMT
Cannot connect to SQLEXPRESS. A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) (more)
category: Data | clicked: 3 | comment | | source: csharpdotnetfreak.blogspot.com
tags: SQL, SQLServer
11
Shouts
spam Shout it Mute it

Microsoft SQL Server Migration Assistant for MySQL v1.0 CTP1
published 1250 days, 16 hours, 49 minutes ago posted by http://quachnguyen.myopenid.com/http://quachnguyen.myopenid.com/ 1253 days, 13 hours, 16 minutes ago
Saturday, January 16, 2010 10:47:24 AM GMT Wednesday, January 13, 2010 2:20:14 PM GMT
Microsoft has made available for download a free tool designed to streamline the migration of MySQL databases to SQL Server. At the start of this week, the company began offering customers a preview version of Microsoft SQL Server Migration Assistant. According to the software giant, the Community Technology Preview of SQL Server Migration Assistant (SSMA) for MySQL v1.0 integrates seamlessly with not only SQL Server 2005, but also SQL Server 2008 and even SQL Azure. The company underlines that the migra... (more)
category: Data | clicked: 1 | comment | | source: code2code.info
tags: SQL
Previous 1 2 3 4 5 6 7 8 9 10 Next