Viewing 15 posts - 16 through 30 (of 32 total)
Thanks! GSquared
Yes, we are hoping that a trigger would do what we want to achieve and use md5 hashing for the purpose.
Regards
Anish
October 20, 2010 at 11:40 am
@Gail: I will perform the monitoring as you suggest...
@dan-2: Yes, there is only one instance. After Gail's recommendations, I have set the max memory to be 64GB and...
September 24, 2010 at 11:14 am
Thanks Gail!
I subsequently found the knowledge base from microsoft:
http://support.microsoft.com/kb/918483
I have also set the max server memory for SQL server to be 64GB. SQL is also x64 and we...
September 24, 2010 at 11:01 am
Hi! Lutz
Thanks for helping out on the weekend.
As I had mentioned earlier we are not using a cursors but, temporary tables with WHILE loop constructs.
I am attaching the stored procs...
September 12, 2010 at 10:23 am
Thanks LutzM for your response. Here's the code with the table structure:
[font="Courier New"]/* This the JOIN which I use to grab the latest sign ups */
SELECT TOP 200
c.CustID,
c.Fname,
c.Lname,
p.BirthDate,
p.MotherMaidenName,
c.Address,
c.City,
c.State,
c.Zip,
c.Email,
c.Password,
c.OpenDateTime,
c.HomePhone
FROM
DB1.dbo.CustomerTable c...
September 10, 2010 at 4:05 pm
Thanks Sumit for your reply.
I tried that bust still no show!!!
But, I did manage to fix the problem by restarting the SQL instance on the mirrored server.
Cheers!
Anish
July 14, 2010 at 8:47 pm
I could make a partition based on Fiscal Year and I think that would help the performance a lot. Can you please point me in the right direction to do...
July 1, 2010 at 12:52 pm
Excellent Michael.....Thanks for your help on this!
I will obviously test this out on a backup copy.....but, this should do the trick 🙂
Michael Valentine Jones (6/30/2010)
June 30, 2010 at 3:59 pm
Thanks for the response Michael
The table occupies 48GB of Space (42 data + 6 index)
And I have enough space on the server to copy the table
Cheers!
June 30, 2010 at 3:24 pm
Thanks LMU
There is a datetime field which I can use to order by.
I am still a layman as far as full-text search is concerned for text mining. Can you...
March 9, 2010 at 4:48 pm
Were you originally tracing events like SP:StmtCompleted in the Stored Procedures category? Have you now changed to tracing events from the TSQL section like SQL:BatchCompleted?
I ask since you didn't...
August 7, 2009 at 9:59 am
Nobody has any suggestions?
Have I posted this in the right section?
August 6, 2009 at 2:16 pm
Was something definitely to do with the filtering. I just ran a trace for over 10 minutes without any filters in place. Even though the system was busy, the CPU...
August 6, 2009 at 2:14 pm
Mmm! I never had a filter on textData...only enabled it on Duration and DBID.
Actually, we haven't upgraded our build yet.....but, I did try the trace again after running DBCC Freesystemcache....
August 6, 2009 at 8:55 am
Thank you Jack!
That seems like it. We are on SP2 build 3050 😛
August 5, 2009 at 9:31 am
Viewing 15 posts - 16 through 30 (of 32 total)