TheSQLGuru

Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 5,841 total)

RE: How to increase performance of a table which is having 16 GB data

ganesh.babu-840100 (3/29/2012)
Try for table partioning. You can send DDL of your table for some more analysis or tips on this.
This is simply bad advice. There are MANY avenues to...

March 30, 2012 at 8:19 am

#1466961
RE: Max Memory - SQL Server 2008 R2 Enterprise Edition (64-bit)

WRACK (3/28/2012)
Did not realise that this topic was still going. Well I have something to report. The client has finally appointed a DBA and I shall gladly handover everything I...

March 29, 2012 at 9:09 am

#1466415
RE: Primary Key: GUID vs. INT

I've already said where! Auto-trading apps, they need to be super quick to find discrepancies in market prices and try to get some profit from it. As you can guess...

March 28, 2012 at 6:13 am

#1465608
RE: SQL Instance on a VM Image

I think most admins will use sysprep to get an image ready to use as a deployable template.

March 27, 2012 at 10:17 pm

#1465454
RE: Primary Key: GUID vs. INT

wagner-670519 (3/26/2012)
Hi Folk,
is it a big performance loose when using GUIDs as Primary Keys?
Greetz Teutales
Yes, it is. Integers are 4 bytes, and CPUs and code are optimized for their...

March 27, 2012 at 10:14 pm

#1465453
RE: Testing Secondary database in Log Shipping

alark (3/27/2012)
GilaMonster, You heard me right. I will bring the secondary databases for testing the apps in DR environment, meanwhile primary databases will continue running in real production. Then after...

March 27, 2012 at 10:05 pm

#1465452
RE: SQL Instance on a VM Image

itpcpro (3/22/2012)
I was wondering if anyone has attempted this? We are wanting to create a VM image with SQL already on it so when we create a new VM Server...

March 27, 2012 at 6:54 am

#1464945
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

>>but I have this strange feeling that you do not know how to do things efficiently in SQL Server.
Absolutely correct - and it shouldn't be a 'strange feeling' either, but...

March 27, 2012 at 6:48 am

#1464939
RE: not getting rid of physical reads

GilaMonster (3/27/2012)
TheSQLGuru (3/26/2012)
I have a client with OLD ADO Classic crappy code on SQL 2005 RTM that gets MASSIVE plan cache bloat. I run a job every 30 minutes...

March 27, 2012 at 6:46 am

#1464935
RE: Index Strategy

I think you absolutely, positively must split the inputs into a firstname and lastname in the UI. That must be part of an efficient solution I think, and it...

March 27, 2012 at 6:40 am

#1464931
RE: not getting rid of physical reads

Confusing Queries (3/26/2012)
GilaMonster (3/26/2012)
Confusing Queries (3/26/2012)
Is it the case we should consider flushing buffers?
No, not unless you want SQL to suddenly have to work much harder than normal.
so, under...

March 26, 2012 at 5:09 pm

#1464644
RE: not getting rid of physical reads

Robert Davis (3/26/2012)
Thanks for the explanation, Gail! That makes a lot of sense.
+1. I like that much better than chewing through plans to evict!

March 26, 2012 at 4:03 pm

#1464603
RE: not getting rid of physical reads

Robert Davis (3/26/2012)
TheSQLGuru (3/26/2012)
1) it is my understanding that if you alter the schema/indexes of a table the plan cache is flushed of plans that hit that object.
If you modify...

March 26, 2012 at 10:02 am

#1464385
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

1) if you want to really see what is going on, run a STATEMENT COMPLETED profiler while this query is running. But BEWARE doing this on a production box!!
2)...

March 26, 2012 at 8:50 am

#1464311
RE: not getting rid of physical reads

Confusing Queries (3/23/2012)
We did not have proper indexes on production and almost all the queries were using clustered index scan having high physical reads.
Now we have created new indexes specially...

March 26, 2012 at 7:18 am

#1464229

Viewing 15 posts - 2,986 through 3,000 (of 5,841 total)