Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

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

NNTP Replication

Stop synchronizing the replication for 2 days.

Hi, I have question reqarding stoping synchronizing the replication for 2
days. I have sql server 2008 running windows 2003. according user's request,
they want me to stopp synchronizing the replication for 2 days. after 2 days,
start to synchronize the replication. I will do following steps to implement

8/22/2010 6:53:03 PM

NNTP Programming

Indexing 101

INSERT INTO #tmpProducts(prodName, prodDescription, catID, sizeID, prodCost,
prodActive) VALUES('Product 1', 'This is product 1', '3', '1',3.25, '1')
I'm just getting into indexing after noticing a very slow query of my main
products table. The table is normalized and only contains 320 records. When

8/22/2010 5:38:48 PM

NNTP Server

Installing on Win7

My computer is running on Windows 7 with Visual Studio 2008 Sp1 and .Net 3.5
sp1
I am not able to MS SQL 2008 and getting compatibility issue error and says
it requires .Net 3.5 to be installed
Any workarounds?!
Regards
Raj

8/22/2010 9:43:03 AM

NNTP Server

Mutually Exclusive Set Comparisons

Hi there,
I've been toying around with a problem for months and have had little success
in answering it; mostly because my limited ability to describe the problem.
I've created a series of queries to set up sample data. I also took the
output, put it into Excel, marked the rows that I want to include with a "1"

8/22/2010 5:51:47 AM

NNTP Server

create View showing a conditional field

How can I create in a view, a calculated field (name) that depends from
other field (value) as follows: if not isnull(value) then (name) ="Discount"
else (name) = null
thanks for your suggestions
LAM

8/22/2010 12:39:01 AM

NNTP Server

Extract month form a datetime field

Hi, something else:
I want to show in a view, the month of a date as fixed format = "00"
Thanks again
LAM

8/21/2010 11:32:07 AM

NNTP Connect

Cheap Wholesale Evisu Coat

Coat [link]
Cheap Wholesale 10DEEP Coat (wholesale free shipping)
Cheap Wholesale 999 Coat
Cheap Wholesale A Coat (wholesale free shipping)
Cheap Wholesale Adidas Coat
Cheap Wholesale Bape Coat <[link] paypal payment>

8/21/2010 6:09:48 AM

NNTP Server

High quality Cheap Wholesale Sweaters

2010 Cheap Wholesale ED Hardy Sweater, Lacoste Sweater, GUCCI
Sweater ect at [link]<Paypal Payment>
Welcome to website
[link]
High quality Cheap Wholesale Sweaters
High quality Cheap Wholesale ED Hardy Sweaters
High quality Cheap Wholesale Lacoste Sweaters [link]

8/21/2010 6:05:26 AM

NNTP Server

Show int field as fixed lenght field

Using a view, I need to fullfill with zeros (0) at the left of whatever
number found in a integer field, converting it to a fix lenght of 6
characters. Also, I would like to know how to show a datetime field under
this format: YYMM
Thanks
LAM

8/21/2010 12:42:46 AM

NNTP Server

partition or archive

What is the difference between partitioning a table and archiveing a table in
sql server 2008?

8/20/2010 3:50:03 PM

NNTP Server

SQL 2005 Best Practices for log files

Microsoft says to put data and log files on different physical disks. I have
already moved the backup files to a different physical disk; can I use this
disk for the log files or should I get another physical disk?
Rich Lawson

8/19/2010 11:37:39 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 43 44 45 46 47 48 49 50
51 52 53 54 55

pBlogCategories

sys.books