I also tried another test on a test server. W2K Enterprise, 4gb ram. Enabled AWE and saw over 3GB of memory being used. I also tried using the Min and Max Server memory settings. When you reduce the Max setting you have to restart SQL Server for it to become effective. It's not dynamic with […]
2004-04-01
Thanks all, especially Steve for SO many replies (I think he's trying to get increase his number of posts )Since starting this thread I have had the chance to perform this operation on a test server and I am gald to say that so long as the service packs are consistent, the restores work without […]
2004-01-30
It is being executed from a client machineIt is a type-oand I'll try the QUOTED_IDENTIFIERSThanks
2004-01-29
1 reads
It looks like the sort of bug where the parser designers never tested a correlated derived table in a select list used with aggregates. This should instead give you an error message, as derived tables consisting of correlated subqueries are generally not allowed. I think it's performing the correlation before aggregating, essentially overriding the aggregation of […]
2004-01-23
Thomas H, the error about "approved" should be fixed now. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-12-29
1 reads
Havent seen that before. Tried backing up and starting from scratch? You're doing plain transactional, no queued or immediate updates? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-20
Hi RandyB, quote: Is there any known way to search triggers in all tables on a db for references to a specific table? this is no complete solution but I hope someone else will provide the missing part SELECT * FROM sysobjects WHERE xtype = 'TR' will give you a list of all triggers in […]
2003-08-27
quote: Can stored procedures be written querying data from 2 databases on the same server? It is nothing to do with the stored procedure. Suely you can query data from different databases by using full qualify name like databasename.objectownername.objectname. For example, select * from db1.dbo.table1 People has different opinions whether they should place eggs into […]
2003-08-20
1 reads
It's a great idea for an enhancement but I don't know of any way to do it at the enterprise level. Stamey is right in that EM does remember it once you set it. But sometimes after you do set it you'll get an error going back into the view later on. The only way […]
2003-08-19
1 reads
DMO is the right tool for scriping. I've done a few DMO articles over the last couple years with lots of different examples: http://qa.sqlservercentral.com/columnists/awarren/allarticles.asp Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-06
1 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
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