Viewing 15 posts - 316 through 330 (of 907 total)
I use perfmon and the counter option. To track exactly what you are talking about. I eventually take the perfmon data and place it into SQL Server tables,...
April 15, 2003 at 9:35 am
You could create a SQL Server Agent job that runs every so many minutes, where the job runs your SP.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out...
April 14, 2003 at 12:37 pm
How easy is it to use?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
April 10, 2003 at 9:28 am
That seems like one possible approach. Does anyone know of any others?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
April 10, 2003 at 8:41 am
The database backup method works great, gets everything and is fairly simple.
Although there is a couple of things you must consider.
First using the database backups will...
April 10, 2003 at 8:04 am
you are dropping table hhhhhh and creating table hhhhhhh. You might try the same number of h's for both the create and the drop.
Gregory Larsen, DBA
If you looking for...
April 9, 2003 at 3:39 pm
I'm not sure exactly what you are looking for. But if you only want to return a single date the max date whether it is CreateDate or DateChgd by...
April 9, 2003 at 3:36 pm
think it goes something like this:
Select a.col1, a.col2 from table1 a where
a.col2 = (select top 1 col2 from table1 where a.col1 = col1 order by col2 desc)
Gregory Larsen, DBA
If...
April 9, 2003 at 9:30 am
Might look at this KB article to give you and idea on how to keep the passwords in sync with a since server. This KB article deals with moving...
April 9, 2003 at 8:35 am
Ok, now I've had my coffee. Ignore my last post.
Yes it might be true you can't build the script, although it is really easy to do it...
April 9, 2003 at 7:47 am
Sorry about that blank post. Of course you understand raid0 will give you no fault tolerance. Also the raid 5 will only slow down your performance when you...
April 9, 2003 at 7:40 am
quote:
What is the best raid configuration for a data warehouse (90/10 read-write ratio)? Right now we have a compaq SAN and everything...
April 9, 2003 at 7:33 am
What I do is edit my package and if I don't have access directly to the other server, I then say "SAVE AS" and store it as a "Structured Storage...
April 9, 2003 at 7:32 am
Thank you for the information. I'll have to check that out.....
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
April 7, 2003 at 9:21 am
If you have an old full backup of the database prior to creating the table, then you should be able to do the following:
1) Backup the transaction log.
2) Backup the...
April 3, 2003 at 12:39 pm
Viewing 15 posts - 316 through 330 (of 907 total)