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
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
The correct answer is in line with what BOL says, but one would think that if I ran the code below I would get "master proc" displayed. But I get "pubs proc". Does this suggest that BOL is wrong? use pubs go create proc sp_test as print 'pubs proc' go use master go create proc sp_test as […]
2004-03-21
yes they can be run on one box, reporting services comes with sql 2000 standard, so you dont need to worry about its license. As far as processor, ram, that depends on your specs, how often process cubes/ reports, how big are your databases. ( I would buy as big as budget allowed)
2004-03-16
Sergio, This sounds like an opportunity to use the partitioned views feature of SQL Server instead of going with the dynamic sql hack. I agree with Jonathan that violating this data integrity rule shouldn't be done lightly. However, you might still make this situation viable by using an updateable view against these underlying implementation tables. […]
2004-03-16
Thanks for your part 1 article. I wish it had been published 4 weeks ago as it took me several hours to get to the stage of being ready to try out the Report Designer (using a real database of ours in a dev VM)! I think I really need to see Part2 - when […]
2004-03-04
Thank you. The second certainly appears on target.Can you give me a reference, just for my network admin's reading enjoyment?
2004-03-03
The correct way to call xp_sendmail using T-Sql is:Exec master.dbo.xp_sendmailThe use keyword in T-Sql is to change the database context in which you are working. YOu cannot do that within a procedure or trigger. When trying to use an objec tin another database you need to use th fully qualified name like in the example […]
2004-02-06
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers