Is there a best practice for laying out a disk structure on a Windows Target
server for an SQL server initiator's drives?  Point being, when configuring
the drives on the iSCSI Host, you format them as the VHD, then should you
format the drives the same way as on the initiator, ...

I've a problem with system database msdb size, because after I run the
maintenance plans " Clean up history" for delete all history < 1 month, now
I've a size of 4.4gb (2.2 data and 2.2 log). Before the cleanup, msdb
database was 2gb.

Ben Forta is Adobe Inc.'s Director of Platform Evangelism and has over two
decades of experience in the computer industry in product development,
support, training, and marketing. He is the author of the best-selling
ColdFusion Web Application Construction Kit series, as well as ...

What the the best approch to do the data sunch between 2 sql servers.
Production db hierarchy columns value change/insert/delete(different
hierarchies are in diff tables) by user applications.
I need these change take place in a remote tables once a day by sql

   I have to modify an existing query as below
existing logic:
and table.location in (select city from tablename1 where col=col)
New logic:

When you excute your query a table using via view, does it compilies
each time when you query or does it uses any kind of stored data in
the memory pool?
Is it querying directly the table always faster (small, medium or

I'd like to know if anyone of you experienced some troubles between sql2000
srv and windosws 7 clients to the other side , or if you know of potential
problem using this kind of architecture.
                     Kind Regards

I am correlating my SQL profiler trace file with Perf Monitor csv data. When
I import the performance data, I see the left side of the line graph is
numbered from 1 - 100. The graph looks great but I do not know what the 1 -
100 represents for my data. Do you know what these tick ...

i have a replicated database (3 GB) with a log file that grown to 38 GB.
The recovery Model is simple.
DBCC Shrinkfile doesnt works.
DBCC OPENTRAN say:

I have one one DBA audit database at one of the instances and looking
at a possibility of setting jobs (row counts, checkdb, etc) across
multiple instances from this databases. What are my options? I would
like to having create stored procedures in each of those instances. Is

You may have heard a lot of hearsay about MBT shoes and their
fantastic functions. MBT shoes are not your normal type of footwear.
They are a completely new healthy shoes concept. They are the first
one of physiological footwear. The MBT shoes can train muscles,

Hi I need to make a select from 2 tables whit this layout always with the
newest datetime exchange currency.
The local cuurency is Mexican Pesos
Table 1 Currencies example:

We are trying to build a consolidated Report server environment that
should fulfill all the requirements for different application.
We have implemented this on SQL Sever by creating different databases
for different applications on the same SQL Instance and then those