Enums in SQL Server

Simon Sabin from SQLServerCentral.com

SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read. More »

Using DDL Triggers in SQL Server 2005 to Capture Schema Changes

Additional Articles from SQLTeam.com

This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced. More »

SqlCredit Part 7: Performance Impact of EncryptByCert and DecryptByCer

Additional Articles from Database Journal

Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.More »

One Year Ago - SSIS At Christmas

Press Release from SQLServerCentral.com ( published: 08/28/2006)

An interesting blog from Adobe on the price of open source software. The poster is a senior VP for Adobe and obviously has some bias in saying that Open Source software that competes with Adobe is cheaper, but doesn't necessarily save money.

The comments to the blog are interesting and I'm sure you can guess what they say. What's interesting is a reference in the blog to a business owner and creative professional that says while he likes open source, he wouldn't base a business on it, at least not for the adobe-like stuff.

I know Linux was in the place many years ago and slowly it's proven that it is possible to actually base a business on this platform. I think it's close now for the average person to think about using open source Office software for their business. I used Open Office for a few years and it seemed to do the job most of the time, but I reached a point where the process of exchanging documents with Office users didn't work. I'm sure it was a short term thing as the Open Office suite made changes to work with newer versions of Word, but at the time I needed to work, so I moved back to Office.

Why didn't I muddle through an upgrade? It wasn't worth the cost savings to me. A $400 savings for Office can evaporate instantly if I have more than a day's worth of issues with another product. The TOC for me is fairly low for Microsoft products. I know how they work, they've been very stable for me, and the amount I pay is pretty low in comparison with the time it takes to get things working and get me productive.

I struggled with getting video capture to work on my PC. It was painful, caused some crashes, and editing was a pain. Eventually I stopped trying to do much with it and gave up on the idea of Christmas DVDs for our extended family. We got an iMac the next year and I was excited to make some DVDs, thinking it would take a few hours to grab some old video and string it together.

Four hours later I gave up because the way the Mac worked wasn't intuitive to me (for video production) and it was frustrating. Online searches gave me so much nonsense, or ideas, thoughts, anything but "making a DVD on an iMac for Idiot PC users" that I stopped messing with it.

That wasn't open source, but it was similar. I have issues on PCs, but not that many. In a business environment, where I need to produce content easily and regularly, anything that delays me or causes problems ends up costing me much more than I'm usually willing to pay.

And why are the corners of those windows in MacOS so #%#$%^#@$@#$ small? It's like they want to be sure us older folks can't resize stuff to the way we want it. Maybe that's what drives those 30" cinema monitor sales!

Steve Jones

» Join the debate, and respond to today's editorial on the forums

» To submit a tip, rant or editorial, email articles@sqlservercentral.com.

Today's Question:

You want to find the latency in transmitting data between the distribution and the subscription database in transactional replication. The time difference between the distributor_commit column in Mstracer_tokens table and the subscriber_commit column in Mstracer_history table will give you the latency for the Subscriber server. In which database can you find these two system tables?

Think you know the answer? Click Here, and find out if you are right.

This Question is worth 2 Point(s) in this category : Replication. We keep track of your score to give you bragging rights against your peers. If you have problems with submitting you can go to the QOD section inside the Test Center directly at http://www.sqlservercentral.com/testcenter/QOD.asp. We'd love to give you credit for your own question and answer. To submit a QOD, simply send the question, answers and explanation to articles@sqlservercentral.com

Today's Question is sponsored by:

Today's Question is sponsored by: Pro SQL Server 2005 Replication

Answer the question for a chance to win a copy of this great new book. We'll be giving away two copies from names drawn randomly from those who answer. It doesn't matter if you answer correctly or incorrectly, but you must live in the US to be eligible.

If you execute this in SQL Server 2005's standard AdventureWorks database, what happens?

select 
	Identity(smallint, 100,1) as ReportID 
	, c.AccountNumber
	, h.SalesOrderID
	, h.OrderDate
	, h.TotalDue
 into Sales.CustomerReport
 from Sales.Customer c
	inner join Sales.SalesOrderHeader h
		on c.CustomerID = h.CustomerID
 where h.SalesPersonID = 279

Answer: This runs and creates a new table.

Explanation: The IDENTITY function can be used to populate a new table based on a SELECT statement. In this case the 429 rows matching the query will be inserted into a new table (Sales.CustomerReport) with the first column being ReportID and populated with the values 100 through 528.

Ref: IDENTITY (Function) - Sales.CustomerReport

Here's a few of the new posts today on the forums. To see more, select Discussion Forums in the Community menu on the site:

   Database Maintenance? - I work in a very small IT shop (3 people) that uses SQL Server 2005 Standard Edition.  We are responsible for producing reports for the company.  I would not consider our databases critical to the operation of the c....(more online)

   Cannot login to server using SQL server authentication - I have a new installation of SQL Server 2005 running on Windows Vista Home Premium Version 6.0.6000. I have never been able to login to the server using SQL Server Management Studio using SQL Server Authentication. I can get ....(more online)

   SQL Server 2005 Linked Server to Oracle - Ok people might see this post and think it is the same old thing about not being to delete rows from Oracle, but it is a little more complicated than that.  Nothing I have seen posted anywhere matches what we are having ....(more online)

   HOW TO VIEW SYSTEM TABLES IN SQL 2005 - I WANT TO VIEW SYSTEM TABLES IN SQL 2005.  IN SQL 2000, WHEN WE CREATE NEW DATABASE MANY SYSTEM TABLES ARE ALSO CREATED AUTOMATICALLY.  BUT IN SQL 2005, I COULD'NT SEE ANY SYSTEM TABLES.AND FROM WHICH SYSTEM TABLE I....(more online)

   SERVER PROB - Hi ALL,My server completely crash, but database restore all data in any other what are the steps we have follow plz telThanks subb....(more online)

   Cube Backup ends in error - Hi all,I have back up job that runs to back up Cube daily but lately it is failing and gives error bellow:The operation has been cancelled.   at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader....(more online)

   2005 Backup retention - Hoping someone can clear this up for me.. We are basically still a SQL Server 2000 shop but recently rolled out 2005 for one particular project.   Trying to get up to speed on 2005 and I am in the process of setting....(more online)

   Restore across a network problems - HiI work on 2 domains A and B. We use mixed mode for SQL Server authentication. I have a dev server on domain B but my backups reside on a NAS box on A.I have mapped a drive to the NAS box N: from the DEV box. I then run....(more online)

   Relational data into Excel by HTTP (like AS2005 data into Excel by HTTP) - Hi,It?s possible to get data in Excel 2003/2007 pivot tables by connecting to Analysis Services over HTTP as described here:http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspxI tried it and it works fine.I?d l....(more online)

   CLR and Performance... - We have a programmer who has coded himself into a corner...and the only solution appears to be a CLR routine to be able to correctly hash the password so that both ASP and ASP.Net version of the code generate the same hash so....(more online)

   Using CLR Stored Procedure to run SSIS packages - Has anyone written a CLR Stored Procedure that takes the name of an SSIS package and runs it?  I am looking at the possibility of building a Service Broker application to handle the daily importing of data from source sy....(more online)

   SQL Assistant & DBPro - We've been doing more and more of our development in the new Team Edition yada, yada, yada,  what was called DBPro or Datadude. Regardless of the name, we've found it to be a terrefic tool. Unfortunately, most of the thi....(more online)

   Using table-variables in dynamic sql - I'm trying to write a stored proc that allows me to get some data from a linked server. If I write the following code, the procedure creates successfully:CREATE PROCEDURE [dbo].[sprocDealSelectDtlItem]  @dealid in&n....(more online)

   sp_Foreachdb and sp_foreachtable - Hi,I currently have a script that gets the table sizes of all the tables in a db. When I run the script on each database it bring back results. I am using sp_foreachtable in the script. Problem is I want the script to bring b....(more online)

   Update statement problem - I used to be able to do the following in SQL 2000 without any problems:Update <table1>Set <field1> = (Select <field2> From <table2> t2 Where t2.<PKField> = <FKField> ) Now in SQL ....(more online)

   Incremental Update on Very Large Table - We have a table with over 5 million rows ( soon to be over 20 million) that store nodes and the distance between them. Create table T1 ( colA int , colB int, colDist float ) These values are re-calculated every hour....(more online)

   Indexed Views - EXACTLY what is stored... - Hi -I'd like to use some indexed views but am wondering exactly what gets stored.   Is it just the columns in the view which are indexed or is it all columns in the view ?  Stored meaning that all art....(more online)

   Unusual performance issues - Hi, guys.This question (or something similar) may have been posted before, but I'm having difficulty using the search function on the site. It returns one page of results (claiming that there are six pages in total), but when....(more online)

   Default Parameter Value in the Reporting Services - Does somebody have experience with reporting services? they are just killing me with their non-flexibility. For the report I am making now the request was not to do it in ASP or .NET but in reporting services w....(more online)

   Script Task - When I select a Script Task it defaults to VB.NET as the language.How do you change it to use C#.NET?Is this possible?....(more online)

   ssis and ssrs interview questions - can any one tell some interview questions in reporting service and integration serviceon sql server 2005 please this is urgent and that will be help full thanks....(more online)

   Iterate over files in correct sequence according to creation date ?? - HiI'm using a ForEachFile iterator to iterate through a bunch of files in a specific folder. I need to make sure though that I iterate through the files in correct order - starting with the oldest one and ending with the last....(more online)

   SSIS Package Hangs - Hi,I am running a fairly simple data flow task that takes a flat file source into a derived column task then into a lookup. If the lookup succeeds it goes to an OLE DB Dest. If the lookup fails, the row goes to another deri....(more online)

   Connection to Access in SSIS - I want to create a package programatically in VB.NET which should have Access as Destination and SQL Server as Source. But I am getting error in AcquireConnection() method for Access Connection Manager. I am using OLEDB as co....(more online)

   How integrated are execution plans with hardware? - I had a disastrous conundrum this weekend while executing a 1 time ETL move I've been working on for 3 months for the largest automotive manufacturer in the US.I developed a data transformation using SSIS on SQL Server 2005 S....(more online)

   How do I allow remote access via an SSL certificate? - We have a few clients that needs to access our SQL database every so often. Currently we're using an IP security policy to block access to port 1433 except from permitted IP addresses. The only problem is, some of the clients....(more online)

   Joining Tables in Different DB''s - Does anyone have any ideas on how to join tables in different DB's without the possiblility of linked servers or replication? I am looking for something along the line of a Data Access Layer in .Net. ....(more online)

   SQL Server Express with Apple Intel - Has anyone had experience with using SQL Server Express on an Intel Apple computer? I'm in the process of designing an application for a friend's company and I'm currently stuck using Access but would like to utilize SQL Serv....(more online)

   SQL Express Reporting Service - I am trying to setup a Reporting Service instance using WinXP and IIS 5. When connecting to http://localhost/Reports/ I receive a metadata error. What can I do to fix this error?....(more online)

   Unable to generate user instance - I have an intel mac mini with Parallels to run XP Pro, plus i i have also tried the following on my P4 IBM laptop:I am learning VB and SQL so i'm very new to everything. I've got visual studio express, also visual web develop....(more online)

   SQL Express on MAC - I am using Virtual PC on MAC OSX (Power PC). I have Win2K3 running with IIS and SQL2000 running. Tried to Install SQL Express but it fails to start. Does anyone have a suggestion on how to get this to work?....(more online)

   Prelogin packet - I'm trying to create a windows service that perform updates from data stored in another database. The windows form application works fine but the windows service give this error:"The prelogin packet used to open the connectio....(more online)

   In cluster setup, Steps are needed to promote the secondary to primary server failure - If the primary master server become permanently unavailable, following a hardware failure for example, what could steps to promote the secondary master to the role of primary master. The Secondary server is a updateable ....(more online)

   Replication Architecture Questions - [apologies for the cross post, I needed this to be in the 2K5 replication forum, and cannot delete my other thread.] Hello everyone,I am looking to use SQL Server Replication for a large hosted reporting solution, and wa....(more online)

   Replication Tools for SQL2005 Express - Hi, I need to replicate data between 2 SQL Server Express Server. Is there a three party tool for this?Thank you.....(more online)

   Using XQuery and looping thru XML data questions. - Hi thereI have a sproc that takes in an XML dataset and I would like to loop through the XML elements in the dataset, convert it to an int and insert them into a table.How would I loop through the XML dataset to get all the X....(more online)

   Update Involving Subquery & Composite Key - Hello,I am trying to finish a query that posts issue slips against the OnHand field of an Inventory table.  Basically the query should look at all the detail records in the issue slip detail table (issue_dx) and subtract....(more online)

   Tables to remove a publication - I restored a db over another db with some replication setup (test environment!). Then I went to add a new publication, but it said the name already existed. Under replication the publication is still lsited but it will not le....(more online)

   saving current indexes prior to using perfrmance advisor''s recommendations - I'm getting ready to apply performance advisor's recommendations for my db's indexes. Many of the recommendations are to drop current indexes (which I'm pretty much in agreement with). Because I'm the cautious type, I'd like ....(more online)

   Reducing reads question - I'm trying to insert all the rows from a table to a new table.(insert A select * from AA)The reads on Profiler shows ar really high value (10253548).First I created a unique clustered index and the reads shows (3258445), then....(more online)

   Major ideas needed - upon working for an organization that supports over 100 instances of SQL (7,2000, and 2k5) All of each type was installed on one single server license. Is there a way to go inside of these servers and find the product key to....(more online)

   Restoring Master Database - Hello All,I'm trying to restore the master database (SQL 2000 SP4) from a backup to a totally different server with different path structures. When I do this, I'm not able to bring up the database instance. I know what the pr....(more online)

   How to Verify the backup - Hi everybody,How to verify that the database backup which we took is good enough to retore it.Thankyou,   ....(more online)

   How to change Unicode comparison style - Hello,I am trying to restore a database on SQL 7.0 using the datafiles from another database. I detached the source and target database then copied the datafiles on operating system level. The source has been reattached witho....(more online)

   Recover data from a operation mistake - I'm using  a ERP app on SQL200 and sometimes the users input several serials numbers of merchandaise to ship and suddenly appears deleted, There is anyway to get the command batch sent from my application to SQL Server l....(more online)

   Maintenance Backup hiccup? - I have a standard Ent Mgr maintenance plan doing full backups every morning. It does a customer database and distribution. A couple days ago the distribution full backup failed with reason the filename Distribution_db_yyyymmd....(more online)

   How do I do I do a multi table update? - I am kinda a new at this and need some help.  I hope this is a simple question.  I know how to update a single table, but now I want to update two tables at the same time and am unsure how to proceed.  Here is ....(more online)

   presenting 25 sorted records from table with 150,000 records - I have a client table with 150,000 recordsfor presenting clients on a form (top 25) i use a procedure"select top 25 * from Clienttablewhere ClientName>=@nameorder by ClientName"with big over 50,000 records the actoin ....(more online)

   How to Unit Test SQL Changes - Hi,I'm wondering if there is any special tool(s) which some of you guys are using to unit test SQL Server changes such as a change to stored procedure, UDF etc...I know some folks are using NUnit for this purpose but apart fr....(more online)

   Creating view - Join on date - I am new to views and have create some straight forward ones.  I have a set of files I am tying to include in a join.  The access to the view will have a specific date, as the program output is date related.  O....(more online)

   Sql Server Logs (no items) showing in Enterprise Manager - When I look in Enterprise Manager under Management, SQL Server Logs, it shows (no items).  There is an errorlog, I can read it by running a query, xp_readerrorlog, and it is in startup jobs.  Does anyone h....(more online)

   SQL 2000 EE AWE Problem - Hi allI've read the following to articles regarding this subject but still not sure if I've understood/implemented AWE correctly:http://support.microsoft.com/kb/274750http://www.sql-server-performance.com/articles/per/awe_mem....(more online)

   Query suddenly runs slowly - I am having a performance problem with a step within a stored procedure that has been running reliably for over two years but has recently slowed to a crawl. This bit of code ran in a few seconds up until about two weeks ago.....(more online)

   Replication issue with Views - Hi all,while testing the load of some scripts on a test database here, i have come across a problem with replication of viewsespecially where a view is referenced by another viewthe error is as such (good for googlers )"Unab....(more online)

   NT Authentication - Can I Change Credentials? - I have inhereted a SQL Server 2000 application with an Access 2003 front end.  Currently users are using SQL Server authentication and that works.  Due to corporate policy I need to switch them to NT Authentication.....(more online)

   Odd Question - Backup SQL server was down for a while and now we are bringing it back up.  On its way back up, we removed log-shipping, as we were going to have to re-do them anyway.  Now when I try to re-register the server, it i....(more online)

   Applying sp3a after upgrading hardware in MSCS SQL cluster -  I have been working on replacing older hardware in an 2 node Windows 2003 SP2 - SQL 2000 sp3a cluster:I removed one node from an sql 2000 SP3a cluster, built a new node, added it back into mscs, then used sql setup to a....(more online)

   Sqlserveragent service started and then stopped - When attempting to start SQLserveragent service, then servie starts and then stops issuing an informaitonal message "SQLServeragent servie on Local Computer started and then stopped.  Some services stop automatically if ....(more online)

   Converting a smallint to time - I have a column in a table that has a datatype of smallint which stores the number of seconds that transpires for a phone call. I would like to convert the data to a time value.For instance, if the value is 133 (meaning the c....(more online)

   How To Get this done - Hi,I'd like to get "best practices" methodology. I have an invoice and line items from two tables in one database. I now have to merge the invoices and line items into a temp table. My question what would be the best appro....(more online)

   sp_OACreate XML and Cursor = SQL Crash - MSSQL 2000I am using the following procedure to create a simple cursor, and within that cursor to Create an XML Document, Load the XML, and then create a pointer to the Root (@root), and then Destroy the XML Document (this is....(more online)

   Search DTS for string - Hello. Does anyone know of a way to search DTS packages for specific strings? I've come across a couple of cool grep scripts in the past but neither covered DTS objects.Thanks.....(more online)

   Column Extraction - There are around 40 columns in my table. I want to get all the table data excluding a particular column; without mentioning all the column names.  I used following code :declare @sql varchar(2000)select @sql=''Select @sq....(more online)

   Are these SP''s still available in 2k8? - The following system SP's are available in SQL 2k and 2k5... and the privs for their usage hasn't changed between the two.  Are they still available in 2k8?  I don't have 2k8, yet, so can't verify myself.  Than....(more online)

   Want SQL query - pls help me in constructing a query for the following dataI am having a table with only one fieldSay table name is Test and field name is Typeand i an having following data in the tableTypeABBBCANow i want result by query asA....(more online)

   70-431 simulations question - This is an odd question, but I don't think it's been asked yet.  And I don't think answering this constitutes brain-dumping.  Let me know if you disagree.On the simulations in the test, I'm assuming they uses o....(more online)

   Recomendations and opinions please - Hi, I want to take the exam for the MCTS Certification in SQL SERVER 2005 (70-431).Actually I'm studyng using the Microsoft's Mcts Self-Paced Training Kit.My questions are:Do I need something else to get ready for the exam?Do....(more online)

   70-431 Microsoft Press Book frustration - So I have the 70-431 Microsoft Press book and the lesson questions are driving me nuts.  It seems to me that half of the answers to the questions don't sound like they belong to the "choice" that was given.  But I w....(more online)

   Hourly Rate? - I am a recently-certified SQL Server 2005 MCTS, with a bit of experience.I have an opportunity to do some contract work, and wanted to know what other DBA consultants were charging, as an hourly rate.Any input here would be a....(more online)

   The other side of outsourcing - Here's an interesting article I found on Bloomberg.com:http://www.bloomberg.com/apps/news?pid=20601109&sid=aNtGr9ytmeYI&refer=exclusiveReminds me of the tech boom in the 80's & early 90's.....(more online)

   SR. SQL DBA/Developer in Northern California - I have been hired by an exciting, fast paced company in the Vallejo/Benicia area to help them identify their next Sr. Database Administrator/Developer opening. This is a direct hire opportunity.  I am seeking the be....(more online)

   Opportunity Knocks for Database Dev''s -   We are looking for a seasoned SQL Server Database Developer with SQL Server 2005 and SSIS.  You should have 2-3 years of experience which includes prior experience WIX and .NET. Our client is a publicly-trade....(more online)

   Full-time SQL DBA needed in Washington, DC - SQL Database Administrator, Washington, DC$80,000 - $90,000+ per yearWe are seeking an experienced SQL Database Administrator/Analyst. This individual would be responsible for the data that goes on the SQL Server, Maintenance....(more online)

   Relational data into Excel by HTTP (like AS2005 data into Excel by HTTP) - Hi,It?s possible to get data in Excel 2003/2007 pivot tables by connecting to Analysis Services over HTTP as described here:http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspxI tried it and it works fine.I?d l....(more online)

   Curisoity about a connection string oddity - Hi, all:I've been up the past five hours wrestling with an oddity, which while it is now functionally resolved, has left me curious. I'll describe what occurred, and then I have a simple question.I fitted a new, faster develo....(more online)

   DTS Package failing to start when scheduled via a job - I am a rookie here so please bear with me on this...I have a DTS package that I created which includes some basic steps (FTP file task...and load the table with its contents). The package works fine when executed on its own b....(more online)

   Front-end Integration (Newbie Question) - A VERY newbie question :I am coming from a MS Access background, and am used to develloping user-interfaces (forms and data access pages) within Access. I am making a career move up to MS SQL Server, and recently became cert....(more online)

   Am I Old-Fashioned? - I function as DBA and developer, both. I find myself running into conflict with other developers on DB server access. My paradigm is that stored procedures are a tier in the n-tier development model, and should form the SOL....(more online)

   Help - Hi All,I want to make an storedprocedure.I'll call some storedprocedure in this new storedprocedure.But,I don't know that How I can take the output field's value of the storedprocedure which I call from the new storedprocedur....(more online)

   Issue w/ SQL Server 2005 Native XML Web Services - I am playing around with SQL Server 2005 Native XML Web Services; only I can't get them to work....I've created a stored proc and tested it.  It works fine.CREATE PROCEDURE [dbo].[GetVerizonProducts]ASBEGIN-- Insert stat....(more online)

   Lotus Approach - I have been in contact with a potential customer, it is a trade association that is currently using Lotus Approach for their membership database of about 3,000 members.I've been offered an opportunity to join the "IT Committe....(more online)

   Does anyone know anything about the company SetFocus? - This company posted a job in Monster.com so I applied. Then I found out if they accepted me, I had to take their business intelligence class for 9 weeks (no pay). Then I have two options - one becomes their employee working ....(more online)

   A Quick Count - I get accused of not writing enough technical editorials and it's probably true at times. Every once in awhile I wander down some strange path and get a bunch of writing done on subjects not necessarily related to DBA work, b....(more online)

   Blogging in your career - I maintain a few blogs, well I maintain a personal one. The one here at SQLServerCentral.com doesn't get so much work, but I'm trying to get better at that. It's hard for me since this editorial is almost like a blog, so ....(more online)

   Die Access, Die - I had to lead with this one because I have a similar view as this post. Access is handy, quick, does a few things nicely, but creates headaches and many more poorly written applications than I think are necessary. And why....(more online)

   1968 - Database software pre-dates Dr. Codd and the 1986 SQL standard. According to Ken North in this paper (PDF), there were a great many people working on coming up with some sort of standard for storing and working with data.....(more online)

   The Price of Time - An interesting blog from Adobe on the price of open source software. The poster is a senior VP for Adobe and abviously has some bias in saying that Open Source software that competes with Adobe is cheaper, but doesn't nec....(more online)

   Does Reporting Services have transaction logs? - Last week I added the reporting services database to our daily user backup maintenance plan.  Today I checked on it to see how it was going.  I saw that the backup of the reporting services database and temporary da....(more online)

   Using drill through reports and excel - HiI have a report showing the results on G/L accounts. Since subreports don't export to excel I've created a drill through report showing the details.When I have exported the main report, I can still drill down in excel to th....(more online)

   Exporting a report - Is there a way to export a report to a txt delimited (tab preferable) file?   My output can exceed the 65,536 rows that Excel allows, so this format will not work for me.   I also can't get csv to work wit....(more online)

   Reporting Services Migration from Delopment to Production Server - Hi all,       does someone knows how to migrate some reports from one server to another?       I have some reports in development server and I would like to mig....(more online)

   Drill through/drill down in sql reports - Can someone please suggest a way on how to use drill down in ssrs?Thanks a bunch! ....(more online)

   Drillthrough toggle is jumpy/twitchy on screen - Hi-The drilldown(not drillthrough in OLAP) functionality is nice but looks HORRIBLE in action.Using it during Visual Studio development works fine, lovely.  Then I deploy it to the web server and blammo - evey toggl....(more online)

   Multiple Client Design - Hi all. I am a software developer designing a new web application for my company. This application is an extension of our currently existing software applications. Our database server is SQL Server 2005. The architecture of o....(more online)

   Table with large number of fields - Refine and implement One to One relations? - Hello everyone,This would be my first post here. I am developing a medical web application. Have started with the database design in sql svr 2005. Apart from the tables for security like User, Role, UserRole, Center etc I hav....(more online)

   Many Intersection Tables vs. Many Entity Tables - All,I am interested in feedback on which of the following is the more efficient and better performing design.  Please disregard syntax and datatype issues.  This is only an example.Also, I am very much leaning towar....(more online)

   Slow performance of Analysis Services queries due to high disk usage during queries - Hi, we have some problems with slow queries in Analysis Services. We recognized extremly high disk usage on the server when browsing OLAP cubes. This happens even when many users touched the server with the same reports, firi....(more online)

   "too large for the specified buffer size" - I'm writing data to an excel spreadsheet from SQL2000 DTS package. I've read plenty about this problem moving data from excel into a table. I've changed the excel guessing in the registry on both client & server. Same problem....(more online)

   The Pitfall of "Not Equal To" Operator in Queries! - Comments posted to this topic are about the content posted at temp....(more online)

   Finding Column Dependencies - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/cbuettner/3214.asp....(more online)

   The SQL Internals Viewer - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dgould/3200.asp....(more online)

   Server Side Paging With SQL Server 2005 - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3181.asp....(more online)

   Calculating Work Days - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jmoden/calcul....(more online)

   SQLBits Community Day - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/3212.asp....(more online)

   Reverse Engineering Alias Data Types in SQL Server 2000 - Part II - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3213.asp....(more online)

Splitting strings

By: Anonymous - Posted: 2/12/2007 6:02:10 AM ()

There are many split-functions out there. This is very fast because there is only two string manipulation functions involved, and not per-part string manipulation.