Server Configuration

view_metadata treated as materialized
A delete command for table_T was moving excruciatingly slowly. Yes, an index helped, but the surprise was that it wasn't an index for table_T. More info: there is a view_V that pulls from two tables, table_T and table_S. The view was created with VIEW_METADATA. Once I put an index on table_S, the delete on tab... 4 Feb 2010 18:00

Restore using MDF and LDF
Hi SQL Gurus, I am still learning SQL Server. I know how to detach and attach databases, also know how to backup and restore databases. I have a question and curious to know the answer. If our SQL Server crashes and if we have a copy of MDF and LDF, can we still restore it or attach it to a new server? Tha... 4 Feb 2010 08:53

Using LIKE..
Hello, [SQL2008] CREATE PROCEDURE [dbo].[uspGdet_temp] @filby Varchar(10), @filval Varchar(50) AS BEGIN SET NOCOUNT ON IF @filby = 'AcNum' BEGIN SELECT * FROM Acc WHERE [AcNum] LIKE @filval + '%' END ELSE BEGIN SELECT * FROM Reg ... 5 Feb 2010 05:03

Optimizer on SQL 2005
I ran dbcc updateusage ('demodb'). I than ran dbcc show_statistics ('location', 'ix_phone'). The update date (statistics update date) remained old. Why? Why weren't statistics updated? BTW.. I have auto update statistics set to on. Thanks in advance ... 3 Feb 2010 12:53

Can't set up new user in Sql 2000
I keep a copy of Sql 2000 on my workstation for those clients who are still on the old software. About a year or so ago, my network user was changed from bev to bevk so it would be consistent with other users. I hadn't had a problem until now, when I was asked to test something on Sql 2000. The job failed to r... 2 Feb 2010 17:35

Placing a SUM amount into a column
Hi, I have the following query SELECT JobName, count (*) as 'RunNumber' FROM Jobs WHERE JobStatus = 0 group by JobName compute SUM (count (*)) In my case SUM has to calculate the total of all count(*) but I need for it to appear in the column next to RunNumber and I need to be able to assign a column name to... 2 Feb 2010 22:27

General maintenance ALERTS
I'm resoponsible on a Critical SQL Server and would like to set up Alerts which will be send to me when things go wrong. In general, Which Alerts would you set for normal tracking? ... 2 Feb 2010 17:35

login Failure for database affter adding a stored procedure
Hi, I am running SQL Server Express 2008 and VWD 2008 Express on a Vista PC. When using MSSMC to create a stored procedure - everything will work fine unless I restart my PC. On restarting my PC after logging onto MSSMC I can no longer see my database - and when running my website in VWD express I get a lo... 2 Feb 2010 17:35

SSIS
Currently, we have a 90gig db which is updated once daily with more than 60 gig worth of data. The update is written in c# and utilizes stored procedures. There are only a few transactions, but they are enormous, I guess to maintain integrity of the data. Is SSIS solid and reliable for the above purpose? Do... 2 Feb 2010 17:35

DB profile and account in DB mail SQLSERVER2005
question is ? 1.how the Dbmail works ? 2.what is DBprofile & account in dBmail and how they work ? 3.if i create two db profiles , how they work ? 4.what is the meaning of default profile "yes" ? ... 2 Feb 2010 17:35