I have a list of 17,000 numbers starting with min(value) = 10,000 and
max(value) = 60,000.  What I need to do is to group these numbers like
group1 contains values between 10,000 and 11,000
group2 contains values between 11,0001 and 12,000

I am trying to do some radius search within a zip code and just to get the
counts it's taking about a minute.
Is there any way I can improve the performance on below query. I already
have an index on zipcode field and also on the field that is used for joins

I have a problem qith a stored procedure.
I try to get the top 10 results of a table.
Select Top(10) * from [Results] order by Zeitstempel DESC
Now i want to create a procedure which get the Position X of this result.

I want to retirve list of all tables from a database in order to there
foreign key reference from another tables.
ie. if A is the parent of B and C. And B is the parent of D, E, F.
then order of the tables are :

I have a situation where currently:
INSERT INTO [TBL A]
   SELECT
   col1,

I'm wondering what easiest method is to deal with foreign (Spanish)
characters in xml data file when loading into database. My vbscript load
fails with element values like "Dímelo" - because of the accented i.  The
files are labeled as encoding="utf-8".  Do I need to parse ...

I have a query on a main table that takes a small number of seconds to run.
I want to link it to a TVF, but when I do the performance is appalling.
There are actually two qualifiers on the join, like this
SELECT *

I found one example of passing parameters and got the following
results.
Given the below example stored procedure:
alter PROCEDURE [dbo].[InsertAS400]

How can this functionality be disabled.  I am running queries against a
remote database on a VPN and the message 'Saving Auto Recovery Information'
pos up every 5 minutes and locks my SQL Server client session for up to 2
munites.

I am trying in vain to CAST or CONVERT an Integer column but I want to pass a
<blank>, not the contents.
So I have this...
CASE WHEN ISNUMERIC(IntColumnName) = 1

When I look at books on SQL, they usually put an 'N' before any text in a SQL
script, but I find the script works perfectly well without it, e.g.
SELECT N'test1 ' + N'test2 '
versus

This is written against a legecy database.
involves hierarchy
Inputs come from a web page
Output is a table for a report

Is there any way to approximately work out how big your backup will be,
before you run BACKUP DATABASE?
Obviously you can get database_size and unallocated_space from sp_spaceused,
but is there then a way to workout backup size?

I need to select the first three words in a varchar field and then the
remaining words (4 to whatever) separately. For my purposes I count a word as
finishing on a space not a full stop or any other character.
e.g. if the string is

I've just started working with SQL Server. How do I look at the text of a
stored procedure? I don't see any obvious way to do it. Thanks.