Topics
Started by
Posts
Last post
Hello, If I create an index CREATE INDEX IX_myindex1 ON mytable (ColumnA, ColumnB); Do I/should I n…
6 replies
Hi, Database integrity job failed with below error. In job output log ,i find below error for one o…
9 replies
Hi Hopefully I'll explain this correctly... I have a table with the AD user name in a field . I wa…
1 replies
I have a SSIS package that was moved from SQL 2005 to 2008 R2. The package was upgraded and it deb…
8 replies
Hi, I want to validate data in a table against an XSD schema. What is the best method? .. TableData…
1 replies
Hi, I have an SQL Server 2008 R2 Backup Maintance plan that has been continuely failing to backup …
13 replies
I have a db table that requires selective pruning of several million rows. I picked a quiet time (…
5 replies
Hi, Why would a scheduled SQL agent job not finish and go into SUSPENDED mode? The job usually take…
4 replies
1. Does guest account get created whenever a new db is created? 2. Can we find when a login/guest l…
1 replies
Hello - My server event log is difficult to work with. I was wondering if there's a way to wire up…
3 replies
I have table as below. create table name (id int, name varchar(10)) insert into name values (1,'as…
6 replies
Hi All, i am creating Trigger in MSDB as mentioned below but after restoring the db Trigger not fi…
2 replies
Hi, I have a requirement that two update conditions may happen for a table A. And we need to store …
4 replies
I've got a table that's using a varchar(9) as the PK / CI that keeps showing up as ~98+% fragmented…
4 replies
Hi all, I've got a script that pulls config values out of the SysConfigures/SysCurConfigs tables, …
1 replies
Viewing 15 topics - 7,861 through 7,875 (of 30,225 total)
You must be logged in to create new topics.