Viewing 15 posts - 43,801 through 43,815 (of 49,552 total)
What are you trying to do with triggers?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 3:10 am
We do full backups(.bak). I did tried restoring the back and still use the current .df and use the old .ldf, error says files are not associated.
What were you trying...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 3:05 am
How often do you have log backups running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 3:04 am
There's no DDL triggers on SQL 2000.
Set up a job that checks for new DBs (maybe against a table that stored the ones that you know are there) and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 2:37 am
select object_name(id), name from sysindexes where INDEXPROPERTY ( id , name , 'IsUnique') = 1
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 2:35 am
Carlo Romagnano (10/14/2008)
Also the DISTINCT clause and the GROUP BY perform an implicit ORDER BY for all cols, but "IMPLICIT" is not the rule nor is written in the BOL.
I'm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 2:31 am
Null comes first because SQL has to do a sort behind the scenes to ensure uniqueness (required by union). Hence there's an implicit Order by 1 ASC on the statement....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:59 am
View definition is not a permission level in SQL 2000. It was introduced in 2005 along with the tightening of the metadata security.
In 2000, iirc, everyone could view the definition...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:50 am
It's possible, it's not usually a good idea. There is a max permissible recursion level of 32. If you go past that, the trigger will fail and the whole lot...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:48 am
There's no such command as ALTER RESOURCES in SQL 2005.
I have this problem where my application is not about to see the disks on my sql server
Could you please explain...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:46 am
SET @UpdatedVendorID = #myupd[Vendor ID]
That's not how you get a value from a table in SQL.
SELECT @UpdatedVendorID = [Vendor ID] FROM #myupd
Also, what's going to happen if more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:40 am
The account that SQL Server is running as (the SQL Server service account) needs to have permission to access that folder.
Check what accounts have permissions on that folder
Check what account...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:37 am
Attach the database read-write, let it recover properly. Detach it again and then you should be able to attach it read-only without problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 1:34 am
Are there any other indexes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 2:45 pm
Your problem may also be poor indexing or poorly written queries. Both of those can easily cause SQL to have to read far more data than it should have to....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 1:01 pm
Viewing 15 posts - 43,801 through 43,815 (of 49,552 total)