RE: Database-Complete (EM) - Does this Truncate the T-log???
Not sure how it does it but I don't see anything different under Profiler with or without it on, but I only have one Test BD with a LogFile not set to autotruncate.
2004-03-22
Failover Clustered Instance (FCI)
RE: Generate object scripts
No, most of it is done using DMO there are examples to do bits and pieces via both DMO and TSQL around here but I have not seen anything to do all either way.
2004-03-22
RE: Auto-creating tables when creating database
Most likely they created the tables in Model. As all db's built are modeled after model then they of course inherit these tables in their design. Check there and they should be there. Just remove and that should end it for you.
2004-03-22
Auto-creating tables when creating database
Hi,I use the SQL server as an example of RDBMS in a database course, but I´m not an expert in SQL Server specific features. When I create a new database using Enterprise Manager, the new database includes the system tables plus 2 user tables. So, I think some of the students have created a sort of system-wide trigger; every […]
2004-03-22
1 reads
2004-03-22
2004-03-22
Moving a Table
Hi..I'm a new DBA to SQL Server. I have three tables that is "larger" than the rest about a 1 million+ rows each and expect to grow greatly. Would it benfit me to move the three tables into seperate data file? If so, how would I move them? Thanks for any input....
2004-03-22
1 reads
RE: Converting Access Query to TSQL
Thanks everyone. Based on your input I was able to change the query so it was SQL compliant. A couple minor changes on the queries Frank and Gary wrote and I was in business. This saved me a lot of time and frustration.Thanks again.
2004-02-03
2003-12-22
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers