Topics
Started by
Posts
Last post
Hi, We are trying to add one column with some default value in a table, which contains 25 crores ro…
2 replies
Hi, I am running a trace to get execution plans on my server. There are quite a few - How can I tak…
2 replies
I am trying to figure out how to detect issues with queries via SQL Server Profiler and trace files…
1 replies
Hi, We have a Comments table with a Date field, and I need to determine the latest comment date per…
5 replies
Hello all, I have a SQL 2005 server that I know is under CPU pressure at times (dm_os_schedulers sh…
5 replies
First off I am new to db adminstration and I am still trying to find my way around the dba world.My…
2 replies
When i execute a particular query the ouput comes in 10 seconds when i select result in Grid.But th…
1 replies
One of SP getting more time to parase SQL Server parse and compile time: CPU time = 38687 ms, el…
1 replies
Dear All, I have installed SQL server 2005 in one of our test server and I am able to login as wel…
2 replies
I have requirement where will get the rows coming in in huge no. per minute in a table what kind of…
9 replies
The following query takes a while(1 to 2 minutes) to return data(around 60000 rows). The table sche…
14 replies
In BOL (Customizing Locking for an Index) click here, there is a blub (between the disallowed locks…
10 replies
I'm seeing a lot to ASYNC_NETWORK_IO is activity monitor. I know this related to the network or cli…
3 replies
Dear All, I have modified the structure of a base table. Now I want to find out all the procedures …
5 replies
I am trying to get SQL Server 2005 to use more than the 1.7 GB of memory it seems to be capped at. …
3 replies
Viewing 15 topics - 1,906 through 1,920 (of 3,249 total)
You must be logged in to create new topics.