Viewing 15 posts - 47,371 through 47,385 (of 49,552 total)
Not quite as simple.
Right click the DB, Tasks -> Export Data
Work through the various steps of the wizard. If you have problems, shout.
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
February 13, 2008 at 9:53 pm
If you want no one to access the DB, sysadmin or otherwise, take the DB offline
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
February 13, 2008 at 9:51 pm
Check the link in the first post. It's a blog post by Conor Cunningham, former member of the SQL Server Query processing team and former development lead on the Query...
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
February 13, 2008 at 9:49 pm
You can save the package out as VB code. If you have anyone there who can read VB, it may be of use.
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
February 13, 2008 at 1:33 pm
Restricted user means that only members of the sysadmin server role or db_owner database rolw can connect to the DB.
Is that what you're looking for?
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
February 13, 2008 at 1:31 pm
Barely. I would doubt it would be visible.
I prefer the .. EXISTS (SELECT <constant> ... format, as it's fairly clear from that that no values are been returned
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
February 13, 2008 at 1:29 pm
Can you post the code, the schema and indexes on the table and an approx row count please?
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
February 13, 2008 at 1:26 pm
It is definitely possible. My work machine's set up that way.
Make sure you install SQL 2000 first (perhaps as the default instance) and then 2005 as a named
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
February 13, 2008 at 1:20 pm
Sugesh Kumar (2/13/2008)
blocking can be avoided using locking hints and isolationlevels.
Or by writing optimal code and ensuring that indexes are appropriate.
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
February 13, 2008 at 9:18 am
Make sure you're running this in the database that the procs are in. Object_name, when passed one param, looks in the current DB.
If you're running SP2, you can use the...
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
February 13, 2008 at 9:15 am
There's a massive difference between the statements
Select 1 where exists(select * from dbo.WordIndex where Term='inc')
and
select * from dbo.WordIndex where Term='inc'
Exists is only checking for the existence of a row. It...
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
February 13, 2008 at 9:10 am
What does the update statement do?
Can it be optimised to take less time? Can the indexes be tweaked so that it doesn't have to lock the entire table?
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
February 13, 2008 at 9:03 am
b_boy (2/13/2008)
Thanks GailIt basically means that db's ment for read only purposes can be cmpressed using the NTFS compression feature.
It's stronger than that. A DB on a compressed drive must...
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
February 13, 2008 at 4:24 am
Duplicate post. Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic454929-23-1.aspx
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
February 13, 2008 at 3:38 am
SQL Server only supports read-only databases/filegroups on compressed drives.
See in books online under "File Backup and Restore and Compression"
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
February 13, 2008 at 3:26 am
Viewing 15 posts - 47,371 through 47,385 (of 49,552 total)