in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » tsql (RSS)

Browse by Tags

  • Dynamic ORACLE SP for calling a linked server database environment based on a parameter.

    I haven't posted anything here yet on this blog, so I thought I'd pull some lesson I learned a while back and use it as a post. If it helps you; great, if not, no worries. The problem I tried to solve involved 5 or 6 Oracle environments that need to have data pulled from them into SQL Server. The user...
    Posted to greenmtnsun (Weblog) by greenmtnsun on Mon, Aug 27 2007
  • What is the position of a row ?

    The simple answer is there isn't one. If you insert 1000 rows into a table and then want to get back the 43rd row you inserted you can't. You can read through all rows and return the 43rd one that the database reads from the table but that is not the same thing. Why is it so? Relational databases...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Aug 21 2007
  • TSQL : How to get messages sent first class

    Leo has posted a great tip about how to get messages output in a TSQL batch without waiting until the batch completes. The trick is to use RAISERROR with a level of 0 http://sqlblogcasts.com/blogs/leopasta/archive/2007/07/03/instant-gratification.aspx - var height=90;var width=720;
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 3 2007
  • Time dimension - What should the key be?

    We are currently implementing a data warehouse and the design of the time dimension was recently being done. Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable. So considering the day dimension what should...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 26 2007
  • Using SMO from TSQL

    If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex. http://www.codeplex.com/SMOinTSQL There are 2 projects in there one an SSMS project and one a C# project. Both can be opened using the TFS in codeplex...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 8 2007
  • Limit a sql script to only run with SQLCMD turned on

    I really like SQLCMDso much so that most of my deployment scripts use SQLCMD. Its got some great features such as :on error exit. Forcing your script to exit when an error occurs. or :r <filename> to read the contents of a file There is one downside and that is if you run a sqlcmd script in management...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Apr 23 2007
  • How to alert on system errors

    Alerts in SQL server rely on the error being logged to the event log. Not all system messages are logged which means you can't alert on them. In SQL 2000 you could hack the sysmessages table, however in SQL2005 you can't. To get round this in SQL 2005 you can use the try catch block. Catch the...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Apr 4 2007
  • Developer Day 4 Demo - Now available

    The demo files associated with are now available. Make sure you read the description first as it includes how to deploy the demo. http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1472.aspx - var height=90;var width=720;
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 5 2006
  • dmvs and CROSS APPLY

    In SQL 2005 there is a new feature by which you can extend a result set with the results of another resultset. You might think thats nothing new because thats exactly what a join is, and with the combination of derived tables you have full control, and you can use table valued functions. However there...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Nov 28 2006
  • Referencing Parent nodes in XQuery is expensive

    Recently a post on a newsgroup caught my attention. "OPENXML vs XQuery Performance", it caught my attention because I did a bucket load of performance testing of OPENXML way back when for SQL Server 2000 XML Distilled and hadn't touched XQuery really. What the poster found was that OPENXML...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Nov 14 2006
Page 5 of 7 (61 items) « First ... < Previous 3 4 5 6 7 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems