Topics
Started by
Posts
Last post
Article in question: http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1…
16 replies
I am trying to tune a view which contains a crosstab built with a SUM + CASE statement. SUM(CASE F…
6 replies
I have a table that is the primary table in the database. I am trying to determine what the best ch…
8 replies
Hi everyone, my dev server has been rebuilding index for five table for the past 95 hours :Whistlin…
13 replies
400+ database servers all running Windows 2003 EE and SQL Server 2005 1 server running Windows 2008…
1 replies
selectpf_id,1,1,1,name,name,ltrim(rtrim(description)) Short_description,ltrim(rtrim(description)) …
1 replies
What is the maximum DB instances possible for SQL 2005 standard edition ? We are planning to run O…
2 replies
I have a foreign currency rates table which gets multiple updates per second. In some cases when th…
2 replies
Hi. I have the following single SQL 2005 server : A.OS= W3K std. edition w/SP2 B. SQL 2005 server …
4 replies
The application I am working with almost exclusively uses views for data access. (The developers he…
3 replies
i want to start benchmarking a system here at work , so as to have hard concrete reasons to justify…
3 replies
HI All, I'm trying to learn more about indexes etc 🙂 now I have set up a table with 3 indexes on it…
3 replies
How to Improve performance on partion View? I have partition view that will fetch data by having un…
1 replies
hi, currently i am using with (nolock) command on almost of my query to speed up the query process.…
7 replies
Hi everyone, I found this in a website "...Another point to note is that an index (clustered or non…
5 replies
Viewing 15 topics - 2,416 through 2,430 (of 3,249 total)
You must be logged in to create new topics.