Topics
Started by
Posts
Last post
want to partition my detail table based on a date field (monthly data i want to partition). But th…
1 replies
What's the disadvantage of having a table with high number of pages.....Does that decrease the perf…
8 replies
Hello guys, I noticed there are some sessions which are inactive for almost 24 hours....Is there an…
3 replies
I had a situation today where a developer came to me to ask me why a query was running extremely sl…
3 replies
We run a maintenance job nightly that rebuild indexes and statistics on our production database. Th…
2 replies
Ok, so, this is really a fairly easy question, and hopefully the answer is.. I know when letting SQ…
14 replies
Heres the scenario... I have a large table with a PK Clustered index on and INT (ID) column I creat…
8 replies
Hello, I have created a user defined data collector set to begin collecting some metrics of perform…
8 replies
On the SQL machine, the PF usage is about 7-8 Gb, The following are the specifications of the machi…
18 replies
Hi, We have an application that queries all tables in a given database in MSSQL 2005 SP3. The goal…
3 replies
Apart from an early morning run where I query the whole databases in time steps/increments, I then …
1 replies
Hello All I have a stored procedure that takes an xml type as one of the parameters. I'm using the…
4 replies
If i run the very simple query below i get a subtree cost of almost 200! If i hardcode the date val…
12 replies
I have a server that is Windows Server 2003 Standard Edition Service Pack 2 that has 2 GB of RAM an…
3 replies
ALTER PROCEDURE [dbo].[LCM_CAMPAIGNINFO] ( @CAMPAIGNID VARCHAR(64), @LISTCOUNT INTEGER OUTPUT, @OPE…
5 replies
Viewing 15 topics - 1,111 through 1,125 (of 3,249 total)
You must be logged in to create new topics.