Viewing 15 posts - 7,786 through 7,800 (of 22,213 total)
Side note: But never use the Profiler GUI against a production system. Always use trace events to capture the information. Profiler is only used to consume the data after it...
July 8, 2014 at 6:38 am
And you can see if there's an index you can create that may help with the sort operation. It doesn't always work, but it's a possibility.
July 8, 2014 at 6:36 am
Also check the default ANSI settings between your local SSMS and the remote SSMS. Differences there can result in different execution plans.
How big are these queries. 30 seconds for a...
July 8, 2014 at 6:35 am
What is it that you're actually looking for? Are you hitting a performance problem?
July 8, 2014 at 6:32 am
Jeff Moden (7/7/2014)
July 8, 2014 at 4:40 am
Most of the functions are the same with 6-8 joins or one. Most of the rules are the same dealing with a few rows or a few million. The real...
July 7, 2014 at 10:04 am
If you're really going to be building a lot of databases, I'd suggest reading Louis Davidson's book. It's a great way to learn how to do database design.
July 7, 2014 at 9:56 am
After you restructure it as was suggested already, this needs to be addressed:
(RTRIM(pc.CODE))
That will lead to scans which will seriously hurt performance. You shouldn't have functions on columns like...
July 7, 2014 at 8:54 am
You can. I haven't done it myself, so I can't offer advice. But it's absolutely doable.
July 7, 2014 at 8:30 am
I'd create a table for the Make. Then I'd create a table for MakeModel. That will have the primary key from the Make and the Model. Then you create a...
July 7, 2014 at 8:28 am
You are absolutely in a tough spot. But if you want to be technical, you don't have many choices.
July 7, 2014 at 8:11 am
No. You can have multiple clusters on shared hardware, but you can't put different versions of SQL Server into the same cluster.
July 7, 2014 at 7:47 am
Because DBCC runs on a snapshot of the database, the two processes won't interfere with each other.
July 7, 2014 at 4:43 am
From this code alone there's no way to tell you how it's going to perform. In addition to the code requests, if you can capture the execution plans, that would...
July 6, 2014 at 4:17 am
Either get a lot more space for the thing so it doesn't fill the drive, or, look into your ETL process and determine what is allocating so much space into...
July 6, 2014 at 4:16 am
Viewing 15 posts - 7,786 through 7,800 (of 22,213 total)