Optimising “Ends With” searches with REVERSE
A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text
2010-01-13
11,312 reads
computed columns
Adding a Computed Column to a Table (2) - SQL School Video
Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.
2009-06-25
4,262 reads
Adding a Computed Column to a Table (1) - SQL School Video
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,629 reads
How to create indexes on computed columns in SQL Server
There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.
2009-03-18
3,781 reads
Create a computed column in SQL Server using XML data
Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.
2008-06-25
3,199 reads
RE: Query Analyzer displaying all int datatypes as decimals....
Maybe you were sleepwalking or sleeptyping... I doubt that this could be set using a tsql command so I must assume it was done by hand... Can't tell who did it from here though.
2005-05-19
RE: New Server what spec
See if these will helphttp://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx http://www.microsoft.com/sql/techinfo/administration/2000/scalability.aspAnd as RAID 5 has been mentioned above, this is definitely interesting:http://www.baarf.com/I would also surf the sites of those hardware vendors. Usually you can find there case studies, that can be useful.
2005-04-22
RE: dbo problem
use datbase name update sysobjects set uid = 1 where uid = 6 This is writing straight to the system catalog which works perfectly but isn't advised by Microsoft.
2005-04-22
RE: Using Word with SQL Server
If you're writing a Web App, Paul's ASP.NET solution looks good; I reformatted it for readability:Function OutputDocumentImage '' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear SQLString = "SELECT WordDocument FROM Translations WHERE TranslationID = " & TransID RS.Open SQLString, DB, 3 IF […]
2004-12-07
Managing Users
I need an application say where a hierarchy level is used in such a way to manage users. For example the parent can create a child node with a username and password. Then the tree goes down. But only each level above has access to the lower level.The tree now has three levels, then the […]
2004-09-05
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers