Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

Famous Software ftp download 2011!!.

Famous Software ftp download 2011!!.
anw...@nextmail.ru
Anything you need,You can also check my website: ctrl + f
[link]
[link]
b/
COADE.PVElite.V2008 & V2007
COADE.PVElite.V2010 & V2009

8/24/2010 1:14:27 PM

NNTP Server

Create Clustered Index on View Problem

Hi,
I've got a annoying problem that our DBA can't help with. We are dropping and
recreating indexes on tables/views in our overnight batch to allow quick
insert of data. This works normally well, however on a couple of occasions
creating the clusterd index on the view takes hours instead of minutes. We

8/24/2010 11:49:46 AM

NNTP Programming

Does using varchar instead of char save space?

Hi,
I came across a table in our database where 2 columns had datatypes of
char(40) and char(20) respectively.
For example, aggregating on the width of the char(40) column gives the
following distribution:
Width Count
37 1062
34 15
33 591
31 7636
30 96912
29 16068
28 13108
27 40326
26 9541
25 14695
24 31267

8/24/2010 9:47:51 AM

NNTP Programming

network traffic encryption

I want to encrypt database traffic to an MSSQL 2000 server.
At the server (Win 2003 server sp2), using the SQL Server Network
Utility, the only enabled protocol is TCP/IP. Force protocol
encryption is checked. The server does have a certificate, issued by
itself, although when I examine it in the Certificates MMC snapin,

8/24/2010 6:59:55 AM

NNTP Programming

Query returning Int instead of Decimal Value ?

Hi,
I am using Sql Server 2008,
Why the following Query returning the Answer : 3
When it should return : 32.692
SELECT CAST(32692/1000 AS decimal(12,5))
Kindly adv.
Thanks and Regards,
Luqman

8/24/2010 5:37:11 AM

NNTP Programming

Strange query performance

OK it's strange to me but maybe that's my lack of understanding. With the
query below when I SELECT GroupID, BSV.ValueAmount without any grouping I get
back 25 rows instantly
WHEN I GROUP ON the GroupID field AND SUM the ValueAmount as ishown below it
then takes 6 seconds.
I do not understand how if SQL can find all 25 rows instantly how can it

8/24/2010 3:59:04 AM

NNTP Server

Failed to backup

Hi,
I have SS 2005 9.0.3228 (SP2 ??)
this server is a publisher for merge replication
every 5 or 10 min there are about 100 subscribers.
Is it too much ??
I can't backup my server (OS backup with Netbackup)
How I can do my OS backup
(skip some files ???)
Thanks for your help

8/23/2010 7:27:14 PM

NNTP Programming

Return only a portion of text

i have the following column which contains user names
GIDS/Martin
GIDS/Alex
I'd like to take out the GIDS/ portion of the text and only return the name
at the end. Thanks for any help.

8/23/2010 6:36:06 PM

NNTP Programming

SUM in SELECT problem

I have the following SQL that is not getting the correct value in TotalPoints
which is coming from a SUM of records for a PeopleLinkID. Can anyone see
what I am missing or have a better solution? Thanks.
SELECT H.PeopleLinkID,
(SELECT SUM(dbo.ActivityCodes.Points)
FROM dbo.ActivityHistory INNER JOIN

8/23/2010 5:30:06 PM

NNTP Programming

Case insensitive XPath query?

Hi,
I'm using MS SQL Server 2005. I have this clause in a query that
looks at an XML column ...
(aaa.category_xml.exist('/cate gories/info_type/category/subc ategory/
@name[fn:contains(.,'Mountain Biking')]') = 1)
Does anyone know a way to make the "fn:contains" clause do a case
insensitive search? Right now the search is based on case but I would

8/23/2010 5:20:12 PM

NNTP Server

how to pass the result of count(*) in a variable in a SP?

Hi,
i want to fetch the number of records in this stored procedure and put it
into a variable for further test.I get an error on the line containing the
IF. How to use variable 'nmber' in the IF statement?
Thanks
Phil
declare @nmber int
select COUNT(*) as nmber from mytable
if nmber >=4
begin
....

8/23/2010 12:51:24 PM

NNTP Programming

Intellisense to SQL Server 2005 ?

Hello,
we have SQL Server 2005 in the server , to get the benefit of Intellisense
at SSMS can I install management tools of SQL Server 2008 R2 in my PC
(Admin) and connect to 2005 instance ? will that work ? what would I lose if
I use 2008 R2 SSMS instead of 2005 SSMS ?
Thank you
Bassam

8/23/2010 9:13:31 AM

NNTP Server

sql 2008 data compression

We are thinking of running compression on our databases now that we moved
over to SQL 2008 ? Our databases are quite huge and was wondering, how long
does it take to compress ?
I guess the answer is it depends.. but would be curious to get some examples
of times.
Also, is it an offline operation .. meaning the table(s) cant be accessed

8/23/2010 4:40:43 AM

NNTP Replication

question regarding replication

I have two questions regarding replication.
1. I have replication that setup as non initial snapshot, and manually
initialize a pull subscription to a transactional publication. When I got
error in subscription and I need to remove the table from replicaiton. But
the error is still there after I removed the table. The transaction in

8/23/2010 4:38:03 AM

NNTP Server

Backup strategy with torn page detection on?

I have 2005 and planning to turn on the torn page detection at the
database level..
If I do a full backup with Init and checksum on and if sql server
encouters a torn page while doing a full backup, does it still over
write the previous backup with an error msg or it leaves the previous
backup intact with an erro msg? This is urgent.. Please clarify..

8/22/2010 9:32:07 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42

pBlogCategories

sys.books