Topics
Started by
Posts
Last post
I am running the following before I call my store procs for testing use [database] go checkpoint g…
3 replies
Hi In windows task manager under process if i chek sqlservr.exe is taking 1.2 GB of memory. Every t…
2 replies
I have the below update statement inside a big procedure. If I comment the below portion, I am savi…
5 replies
We have installed SQL 2005 for a Help Desk database. I don't have any experience with SQL, so would…
7 replies
Is there a performance difference between these 2 calculations? IF DATEDIFF(SECOND,@StartDate,@EndD…
3 replies
Hi All, I have a query which is joining two tables: Tables A is 100000 and Table B is 275Million bu…
8 replies
Hi, A quick question:- Besides, by looking upon 'avg_fragmentation_in_percent' in sys.dm_db_index_p…
21 replies
Hi, The same query runs in 1 second when logging into my DB using Windows Authentication login, but…
5 replies
This is my first post on here so bare with me. I have a sql query that I have run on two different …
3 replies
Hi, I have a store proc which is taking like 10 mins to bring back 13000 rows. I have to admit that…
46 replies
Hi, I am using a vendor purchased product for managing customers and i am getting very slow perfoma…
1 replies
Hi, need a little advice, If I reorganize an index should we or will it be good if we update the st…
3 replies
Hi All, I have an issue where my sproc needs to be tunned. Now its executed within 54 sec and fetec…
10 replies
Dear All, I want to do some certification (DBA) on Sql Server. Kindly guide me how to proceed..? Th…
5 replies
Hi.. I am new to Index in SQL Server. Pls provide some info about When to use Clustered Index &…
2 replies
Viewing 15 topics - 2,026 through 2,040 (of 3,249 total)
You must be logged in to create new topics.