Viewing 15 posts - 8,926 through 8,940 (of 9,208 total)
Lynn Pettis (8/25/2008)
why the joins, group bys, and having count(*) >
the group by would be required for the count function i think
August 25, 2008 at 2:11 pm
marius.draganescu (8/25/2008)
It looks like this is it!! It is working...
can you recommend a book/ website/ anything else I could use to learn the more complex TSQL from? I...
August 25, 2008 at 2:04 pm
whether you step through each index or grab the database name and rebuild all its indexes it'll take the same amount of time. I would use a cursor to grab...
August 25, 2008 at 1:59 pm
how many nodes\sql instances are in the cluster
August 25, 2008 at 1:54 pm
ensure users are mapped to one of the MSDB standard DTS roles
db_dtsadmin, db_dtsltduser, and db_dtsoperator
or create and assign a custom role. Users need to have correct permissions to execute...
August 25, 2008 at 9:39 am
marius.draganescu (8/23/2008)
I will try this out Monday and I will let you know how it works. Many thanks!!!
no problem, table aliasing also helps to compact\tidy your code a little (dont...
August 25, 2008 at 4:35 am
you could use IPSec to secure communication between the 2 machines
August 25, 2008 at 3:56 am
are these packages stored in the MSDB database?
August 25, 2008 at 3:54 am
sql 2005 enterprise can only be installed to appropriate server operating system. For Vista\XP you will need developer or express edition
August 25, 2008 at 3:53 am
marius.draganescu (8/22/2008)
Duck ...
August 23, 2008 at 6:08 am
hengert (8/20/2008)
I used "1/1/1900", maybe it only accepts single quotes then. I'll give it a try. Thanks.
yes you need to use single quotes
August 22, 2008 at 9:52 am
unikhath (8/22/2008)
Yes, I'm installing Developer edition on my machine for development and using Enterprise edition on the clients site during production.Thanks for the help.
should be just fine
August 22, 2008 at 9:50 am
probably need to clarify a little further what you are intending to do
August 22, 2008 at 9:49 am
Thayal Muhunthan (8/22/2008)
FOr SQL data, logs, tempDB, I have SAN disk.
if the RAID 10 storage for all this is SAN based then thats a different situation all together. 146...
August 22, 2008 at 9:43 am
Ray Herring (8/21/2008)
and your growth is small then you can end up with a very large, very fragmented file.
shrinking and growing files can cause fragmentation at the file level too
August 21, 2008 at 4:41 pm
Viewing 15 posts - 8,926 through 8,940 (of 9,208 total)