Viewing 15 posts - 166 through 180 (of 519 total)
You would need to get the rowcount ahead of time, and use a variable to pass it in as the subject line. It's simple enough, but you will be running...
March 27, 2003 at 6:31 pm
I wrote a script a couple years ago that takes a set of tables and does the same thing. Mine builds out the database using the same filegroups and file...
March 27, 2003 at 6:23 pm
quote:
Capital One has an Oracle 6boxcluster, 4-way app. (24 CPUs)SQL Server couldnt handle certain queries.
All the CC data i think.
March 26, 2003 at 3:59 pm
Sounds like you working with it from a mdb. Change over to using the adp functions, and you'll eliminate the majority of your overhead. I won't say that it's not...
March 25, 2003 at 2:58 pm
quote:
I couldn't agree more. In my opinion, these statements are either based on old experiences or on SQL Server instances not very...
March 25, 2003 at 8:32 am
quote:
You certainly can tell the difference between an update & insert trigger in SQL Server. Postmod values are available in triggers...
March 24, 2003 at 2:08 pm
Yes, the tables replicated are the same. However, the data will be partitioned by data ranges within the tables (In a reliable manner I pray....).
What you mention is also one...
March 24, 2003 at 1:01 pm
It very much depends on what your wanting to see as to how often to run it. In most cases, I run it every hour for logging, to allow me...
March 24, 2003 at 11:24 am
If you recieved a MDF and a LDF file, I would have a hard time believing it was a backup, unless whoever it was named the backups that way....which I...
March 20, 2003 at 8:14 pm
1. Not positive, but it's the route I take, then restore after the rebuild if neccessary (objects in master to recover)
2. This is the directory the origional was in.
3. This...
March 20, 2003 at 8:03 pm
The second option you state is how it should be done if that is the case.
Use
Begin Tran
Update Groups set Percentage = 60 Where Person = Bob
Update Groups set Percentage...
March 13, 2003 at 6:05 pm
Why not group by on your group ID, and sum the percentages, allowing you to check for 100 with a where clause? Say something like:
Select GroupID,Sum(Percentage)
From PercentageTable
Group BY GroupID
Having SUM(Percentage)...
March 12, 2003 at 3:36 pm
One method could be:
You can determine changes to the schema of your databases with the create date and version columns in the sysobjects tables, if you record the previous values...
March 6, 2003 at 12:10 pm
you can detach the database and re-attach it after moving the actual file. (sp_detach_db, sp_attach_db)
you can back up your database, and restore it to the new location.
just a couple methods...
March 5, 2003 at 12:02 pm
Viewing 15 posts - 166 through 180 (of 519 total)