Current Category Subscribe to the RSS feed for this category
SQL Server
Parent Categories
All Categories
Child Categories
Analysis Services
RobBowman,

I came across (thanks Paul) a great way to quickly generate test data for SQL Server today. DECLARE @rows INT, @a int SET @rows = 50 SELECT * INTO dbo.RobTest FROM (SELECT TOP (@rows) Rownumber = ROW_NUMBER() ...

TATWORTH,

Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; ...

DevJef,

In SQL Server we know 3 kinds of temporary tables: Local Temp Tables, Global Temp Tables and Table Variables. In this blog I will try to explain the differences, and tell you how to use it. Local Temp ...

TATWORTH,

At http://www.sqlsharp.com/fea... there is a series of SQL CLR functions for SQL Server 2005 and later. The basic set can be downloaded for free! For $200, an additional 50+ functions are available. ...

OceanWanderer,

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; ...

ZacHarlan,

Yesterday I got to participate in a very encouraging experience. I got the opportunity to collaborate on a project I've been working on with another talented developer. Being able to collaborate on this ...

DevJef,

How many times do you wonder about when an object was last updated? You can find out by using the default sysobjects in SQL Server: USE Adventureworks DECLARE @DBID INT = DB_ID('Adventureworks') SELECT ...

AnkitAgrawal,

At the beginning I want to inform that I've already read the similar question here: Entity Framework 4.0: is it worthy now? but it does not answer my questions and doubts concerning EF 4.0. Here's the ...

joeeames,

I was recently discussing some common flaws in application architecture with David Adsit (codeobsession.blogspot.com/) about wisdom in development. Have you ever looked at a system and seen somethings ...