Yes, you can connect this database to 2005, however, when you attach these files, the structure is internally converted to a 2005 database. Which means, you can't detach these files...

and after the rebuild, you'll have your "wasted space" back in your database .... 🙂

Sorry, I posted the wrong answer. Try this:

print '*** Creating objecten voor DBSize'

print ''

if not exists (select 'yes' from sysobjects where name = 'dbsize')

BEGIN

CREATE TABLE DBSize(

[Servername] sysname DEFAULT @@SERVERNAME

, [Servicename]...

try this:

select * from sysfiles

Why do you have more than 1 logfile? It won't acclerate your database ....

start your query with:

SET NOCOUNT ON

1) go to SQL Agent -> alerts

2) right click on alert and select "New Alert"

3) On tab "general", set:

- name: process blocked

-...

DISCLAIMER: It's very important you'll know the concepts of a logfile. Start reading Books on Line, or search this site. My answers to your question are very basic. How you...

No, that's incorrect.

See the exact formulas for determing a leap year on http://en.wikipedia.org/wiki/Leap_year

Not exactly knowing how you manage your database, consider:

- statistics are created and updated

- indexes are analyzed and rebuilded/reorganized

- check for fragmentation (logical/physical/disk)

Also:

- check the location of your data- and...

No. Found the original location: http://www.mssqltips.com/tip.asp?tip=1527

Found this trick for determing a leap year (thought it came from this site)

if object_id('udf_IsLeapYear') is not null

drop function udf_IsLeapYear

GO

create function dbo.udf_IsLeapYear (@year int)

returns bit

as

begin

return(select case...

Some tests is did:

create table wdi(datum datetime null)

insert into wdi(datum) values ('')

insert into wdi(datum) values (NULL)

select * from wdi

drop table wdi

output: 1900-01-01 00:00:00.000

...

Do you want a NULL value, or a default value, when no data is specified?

If you allow NULL values, check/alter the table definition

For default value, add a default constraint to...

See this excellent article about recovery models: http://www.sql-server-performance.com/articles/per/Database_Recovery_Models_in_SQL_Server_p1.aspx

"It depends"... 😛

Yeah, I know. Being an Oracle DBA for 8 years, I have to say some (many?) functionalities are more sophisticated, compared to...