Topics
Started by
Posts
Last post
Yesterday I upgraded a Windows Server 2008 R2 server from SQL Server 2005 SP4 to SQL Server 2008R2 …
5 replies
Is creating covering index the only solution to remove key lookup in the execution plan?
2 replies
We have a database for network application Vcenter. it is setup to simple recovery mode, the databa…
8 replies
When running a query on sys.dm_db_index_physical_stats to get the fragmentation level of an index …
8 replies
Hi All, I had an issue of log space running out of space. So as master Gail as suggested, I h…
5 replies
Hi, How can I know what is the CAP limit for the CPU and how can i set it to the optimal value
7 replies
We get data in this format from a different dept. and I need help with SQL query so that the data c…
2 replies
Would there be any slowness in performance if a query involves dateadd(day,datediff(day,1,GETDATE()…
2 replies
**moved from data corruption forum** The Master database on one of our servers is showing in SSMS a…
3 replies
Hi All, I have looked all over the internet and have not found anything that comes close to answeri…
1 replies
Hi All, I am trying to partion an existing table in our environment. The issue is it alredy has a …
1 replies
I want to grant EXEC permissions to all Stored Procedures in all User Databases. EXEC sp_msforeac…
3 replies
How to grant create table permission to a role or user in SSMS and T_SQL? Thanks
1 replies
Hi there, I have a problem with a maintenance plan task which executes a query to disable and later…
1 replies
Hi I use the below script to find out the space consumed by a particular DB. It works fine for me. …
3 replies
Viewing 15 topics - 2,911 through 2,925 (of 6,200 total)
You must be logged in to create new topics.