We have a senior developer pushing hard about this new Cloud services
from Amazon and Microsoft.
Are there any good articles explaining clearly the pros and cons?
I plan on pushing for SQL 2008 but I'd like to find out what the

I have an AdventureWorks database that I created a snapShot
(AdventureWorksSP).  I deleted several ContactIDs from the Person.Contact
table.  I drop the Person.Contact table from the AdvenureWorks database.  I
would like to use a SELECT * INTO Person.Contact From AdventureWorksSP ...

A discussion for the storage experts in the house.
We are setting up a new SAN, and there are two schools of thoughts:
* Have 2 6-disk RAID-5s, grouped together as one (meta?)LUN, thereby
effectively setting up all data files (log files get a separate

What types of documentation are normally found within a DBA team?  Does
anyone have a set of standard templates that they can share?  Also,
checklists that you can share would be greatly appreicated.
Also, looking for a template for standard operating procedures.  Also,

How do I schedule an export of all database objects (tables/views/SPs/...)
to scripts on disk?
Not interested in any table data.
Using sqlserver 2005 express.

Select
AF_LINGUAGEM_TRADUCAO.VARIAVEL,AF_LINGUAGEM_TRADUCAO.TRADUCAO,plan1.Portugues,plan1.Ingles
From AF_LINGUAGEM_TRADUCAO Left Join Plan1 On (portugues=TRADUCAO) Order by
Variavel

Hi,
I have a star scheme (sql2005) with > 10 000 000 transactions in fact-table
and 5 dim-tabels with > 10 000 products/customers etc each. All dim-tables
and the facttable contains several comment-fields; varchar(500), frekvently

We have got rig with SQL SERVER 2005 Primary and Backup consisting of two
database one configurationon which Transactional Replication is running.
Other is Logging database which logs all the activites of our Applications.
We are experiencing issue where in a week or so SQL ...

Ok, I am just exploring the Bitwise operations in SQL. I like the fact
that I can take a field called GroupID int, and store the Groups in
which the user is subscribed to. such as Group 1 and Group 16. and all
I have to do to check if the user is in that group, I do:

Hi
I tried to shrink additional tempdb data file that are not default data
file(tempdev). Can somebody tell me how to do that? Thanks

I am shrinking data and log file size of tempdb, and I use dbcc shrinkfile to
do that. After I ran that command, the initial size of the files don't change
at all. Do I need to re-start sql server in order to make it changed? Thanks.

i have created the following stored procedure with the assembly file from
this article :
http://www.sqldbatips.com/showarticle.asp?ID=23
the thing is that i have tried

We had sql server 2000, and we used HTTP support to run some XML queries
directly from the database using internet explorer. It was easy to configure,
using "Configure SQL XML support in IIS" tool. I was able to create Virtual
directory using this tool, and to run for example:

i have moved a DB from sql2000 to sql2005.
i got one of the Stored Procedures this error :
quote
--------------------------------------------------------------------------------

Would love to hear from a Microsoft Person about this.
Have been dealing with tables around 100 Billion rows.
Everything is fine, sub-second 300 ms always possible with proper indexes.
The problem is "Joins".