Topics
Started by
Posts
Last post
Hi Guru, I have a customer search table which has about 4 millions unique records. We search a reco…
5 replies
I have a server that is going to be working as a reporting server, very few writes (once a day data…
8 replies
I've read numerous articles telling us to avoid using cursors wherever possible in favour of while …
3 replies
USE [Pubs] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spMedia_Media…
4 replies
7/01/201019:33:18SQLWEPErrorNone124N/AServername"CREATE QUEUE permission denied in database…
1 replies
I need to give grant permission for views. but i need give grant permission for base tables also. i…
1 replies
Does someone knows if the threadshold Target Memory is How much memory the Sql Server would like to…
14 replies
We have been experiencing extreme latency when running DTS packages importing information from an O…
20 replies
When running profiler I have noticed that the sp_execute statement runs quite often. I think …
4 replies
Hi all, I have a table with around 30 millions records. Most of the query created is using select d…
7 replies
I have a union all statement inside a nested query. As you can see, the below query doesn't need to…
1 replies
Hi, I am stumped by the following: I have a fact table of about 60Million rows called search_fact. …
3 replies
we have an application that uses prepared SQL statements sent from a ASP.NET application. The…
3 replies
I have writting an after trigger for insert for a table. When a record is getting inserted it is ex…
2 replies
Query A UnCached does 2+ Million logical Reads with lots of scans and takes over 2 minutes to execu…
4 replies
Viewing 15 topics - 181 through 195 (of 2,581 total)
You must be logged in to create new topics.