Topics
Started by
Posts
Last post
I have a pk that has a uncluster index and is referenced by other 10 fk in 10 other tables if I add…
3 replies
We had some issues last with our SAN. Even though the databases are now back on-line we are experie…
2 replies
Hi all I would to know when a user last used a database via ssms, is there a way to do this? Eithe…
1 replies
Is there a script to check if the index if highly fragmented rebuild otherwise reorganize to run it…
2 replies
Hi, Total 600 GB HD, and configured RAID 5 in OLTP SQL server 2008 R2, C drive 80, D drive 520 GB A…
3 replies
Over the weekend, we got quite a few SQL server alert severity- 017 Insufficient resources. In wind…
16 replies
We have a sql server 2005 sp2. In maintenance plan I recently changed a database to simple recovery…
1 replies
hi i would like to create 2 databases with the same name on the same server but with different ip a…
7 replies
Hi, How do i find out if a nonclustered index is already compressed? Thanks
2 replies
We have a production database which contains a nullable column which we would like to make non-null…
6 replies
I have a database one of the tables has the primary key set to be nonclustered by mistake and a lot…
3 replies
I have a table CREATE TABLE [dbo].[Airline]( [airlne_cd] [char](3) COLLATE SQL_Latin1_General_CP1_…
5 replies
I have a database of vendor product, the database data file size is about 13 gb. We want to clean u…
2 replies
I have a non cluster index (primary key of a table that is referenced by several foreign keys all o…
2 replies
I have a vendor product that has some tables like track each change or history of activity, which m…
2 replies
Viewing 15 topics - 3,976 through 3,990 (of 6,200 total)
You must be logged in to create new topics.