Home › ASP.NET Weblogs
All Tags » SQL Server » SQL (RSS)

Browse by Tags

Related Posts

  • SQL Champ

    English Portuguese A nice SQL Server 2005 quiz created by Software Architecs . The quiz has 7 technical questions about SQL Server 2005. My Results?   Quiz link: http://www.software-architects.com/TechnicalArticles/Quiz/tabid/82/language/en-US/Default.aspx Source: Cristian Lefter blog Um quiz muito...
    Posted to Felipe Ferreira (Weblog) by Felipe Ferreira on 06-10-2008, 12:00 AM
    Filed under: SQL Server 2005, SQL, SQL Server

  • Last date of the month. sql date process

    I was requested to make a store procedure that is able to retrieve results from a log table based on the today's month, which has to start from the 1st day of the month to the last day of the month. After a no-brainer's action: Google it! some results were found and quite useful. but most of the version...
    Posted to Tien Chun Wang (Weblog) by protienshow on 03-03-2008, 12:00 AM
    Filed under: SQL, SQL Server

  • Como armar un rango de fechas en una tabla temporal en SQL

    Este es un truco que utilizo para mostrar datos por fechas, donde no tenia registro para una fecha dentro del rango. Así, que ¿como mostrar las variaciones entre esas dos fechas?. Primero crear una tabla temporal, con las fechas y luego un left join con nuestra tabla de datos. Así seria el script: .csharpcode...
    Posted to Bernardo Raskovsky's Blogs (Weblog) by Ber_Arg on 02-27-2008, 12:00 AM
    Filed under: Tips and Tricks, SQL, SQL Server

  • Adding simple trigger-based auditing to your SQL Server database

    How do you track changes to data in your database? There are a variety of supported auditing methods for SQL Server, including comprehensive C2 security auditing , but what do you do if you're solving a business rather than a security problem, and you're interested in tracking the following kinds of...
    Posted to Jon Galloway (Weblog) by Jon Galloway on 01-27-2008, 12:00 AM
    Filed under: SQL, SQL Server

  • SQL Server Interview Questions and Answers

    Awsome list of SQL Server Inteview Question by Pinal Dave ...Hats off pinal. Download SQL Server Interview Questions and Answers Complete List Complete Series of SQL Server Interview Questions and Answers SQL Server Interview Questions and Answers - Introduction SQL Server Interview Questions and Answers...
    Posted to Suresh Behera (Weblog) by Suresh Behera on 12-28-2007, 12:00 AM
    Filed under: .Interview, SQL, SQL Server

  • ASP.NET Podcasts

    After going on holidays, feeling relaxed and generally not doing much tech related stuff, I have fallen behind in a number of things. One was my inbox, something like 1400+ messages I have had to wade through, and they keep coming. However, the other is the podcasts. Wally has been producing some podcasts...
    Posted to Glavs Blog (Weblog) by Glav on 07-20-2007, 12:00 AM
    Filed under: ASP.NET, .NET, podcast, Architecture, Windows, SQL, SQL Server

  • The real reason SELECT * queries are bad: index coverage

    Are SELECT * queries bad? Sure, everyone know that. But, why? It's returning too much data, right? That's the common answer, but I don't think it's the right one. If you're working with a reasonably normalized database, the actual network traffic difference is pretty small. Let's take a look at a sample...
    Posted to Jon Galloway (Weblog) by Jon Galloway on 07-18-2007, 12:00 AM
    Filed under: SQL, SQL Server

  • [T-SQL] Getting distinct, current entries from tables with timestamp / datetime fields

    It's relatively easy to store data with a time dimension, but querying it is another matter. If you select from a temporal tables (one which includes historical information indicated by a timestamp or datetime column) based on your ID, you'll get a lot of duplicate records; only one or a few of those...
    Posted to Jon Galloway (Weblog) by Jon Galloway on 07-12-2007, 12:00 AM
    Filed under: SQL, SQL Server

  • VSTS for Database Professionals on my current project

    On a current project I was interested in using VSTS for Database professionals to see if it could add any value with database management. Traditionally its been a very manual process as Visual Studio has not had any real support for it. I also knew that Nick Weinholt is due to present at SDNUG on the...
    Posted to Glavs Blog (Weblog) by Glav on 05-28-2007, 12:00 AM
    Filed under: .NET, Visual Studio, Architecture, SQL, SQL Server

  • [SQL] Force the protocol (TCP, Named Pipes, etc.) in your connection string

    Barry Dorrans recently mentioned that you can force the database connection protocol by specifying np: or tcp: before the server name in your connection string . I've jumped through some hoops before using localhost to target tcp and (local) to target named pipes, but it looks like there's a much better...
    Posted to Jon Galloway (Weblog) by Jon Galloway on 02-24-2007, 12:00 AM
    Filed under: Tips / Tricks, SQL, SQL Server
Page 1 of 6 (53 items) 1 2 3 4 5 Next > ... Last »

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2010 Microsoft Corporation.

  • ASP.net
  • Silverlight
  • Channel 9
  • TechNet Edge
  • IIS
  • MIX
  • MSDN
  • Windows Client
Microsoft Communities