Clustered index and database ordering
Thu, 21 Aug 2008 22:15:11 +0100
I've been reading about clustered indexes, and I'm confused.
My understanding is that the rows are actually ordered within the database
based on the clustered index. In that case, what happens when I add a new
row? Does the database re-order itself so that the new row is in the correct
place in the database ...
|
Retrieving Row Numbers
Thu, 21 Aug 2008 10:07:17 -0600
Greetings,
Using SQL Server, I'd like to query a simple table. But I'd like one of the
columns returned to be the row number of that row (the row number would not
actually be stored in the table).
I searched the Web a little and found ROW_NUMBER(), however it requires an
OVER statement that doesn't make ...
|
SQL Server 2005 or 2008?
Wed, 20 Aug 2008 23:20:50 -0700
Hello,
My company is going to purchase the developer and the enterprise edition of
SQL Server, we are going to be using Vista as our operating system and I
wondering would it be better to get the newer edition 2008 or stay with
2005. Also, is there a big difference between 2005 and 2008? If so what
can it ...
|
sp_send_dbmail] @query_result_header = '1', not working
Wed, 20 Aug 2008 16:03:30 -0700 (PDT)
When the below is executed and the email is sent there are no column
headers.
What did I miss? I read by turning that bit to "1" the email would
include headers?
Thanks in advance.
exec [msdb].[dbo].[sp_send_dbmail] @profile_name =
'dbmailden', @recipients = 'email@email.com',
@subject = 'Weekly Tic ...
|
Sql Server management studio?
Wed, 20 Aug 2008 06:30:19 -0700
Hello,
Currently I have SQL Server 2005 Express editon in my PC. I decided to
download SQL Server 2005 Enterprise Edition (180 Days Evaulation from
Microsoft) When I finished installing the software I get Visual Studios
2005. I didn't get SQL Server Management Studios. What Gives? I want to
get 2005 ...
|
Connecting via ODBC Connection in Sql Server 2005
Tue, 19 Aug 2008 22:35:18 -0700
Hello,
I am such a newbe I need help. I just have SQL Server 2005 installed in my
work PC and I trying to figure out where do I go or how do I connect via
ODBC to AS400 from SQL Server Management Studio 2005. I create a ODBC link
from our AS400 accounting database. I want to access the data. I could
...
|
Help with Query Syntax
Tue, 19 Aug 2008 19:24:27 -0600
Okay, I figured out the following syntax to return rows from a table with
one column equal to the number of references in another table.
SELECT ID, (SELECT COUNT(*) FROM Topics WHERE (CategoryID = Categories.ID))
AS TopicCount FROM Categories
But I'm wondering if there is any way to limit the results to th ...
|
|
|
XP_Sendmail Issue
Tue, 19 Aug 2008 17:19:43 -0700 (PDT)
SQL 2005 SP1 non clustered Standard Edition
Error from Query Analyzer when I run this; because of this snippet of
my t-sql
exec sys.xp_sendmail @recipients = 'dwhite@globalsecurecorp.com',
@subject = 'SQL Server Report', @message = ''query",
@attach_results = 'TRUE', @width = 250
"xp_sendmail: Either the ...
|
Help with COUNT()
Tue, 19 Aug 2008 15:58:44 -0600
I want to write a query where one column will contain the number of items in
another table or query, but I'm not sure of the syntax.
For example, say I want to query a Regions table and I want one of the
columns in each row to be the number of Customers in that region. So, I'm
thinking something along these ...
|
Help with Dynamic Report
Mon, 18 Aug 2008 11:52:05 -0700 (PDT)
I want to execute a report once a week so the day clause would be
"now" and previous 7 days.
I have the query critera working fine; I just can not figure out how
to grab the last 7 days within the query,
I had as a varible that users entered and that works.....I need to
remove that and make it 7 day totals. ...
|
