Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).
2008-08-12
3,021 reads
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,046 reads
When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?
2008-03-11
3,488 reads
That's a nice try but:Trucate will Log Page deallocationTruncate Requires Elevated PriviledgesTruncate can't be executed if the table has foreign keysTruncate will LOCK the users out so if you try this in a multiuser environment you will get a lot of failed transactions ... Too many problems
2005-04-13
Thats your BrightStor (BEB) database file (used to be ArcServe). You'll need to check with your network admin that takes care of the network backups to ensure that he is purging out the old data. However, depending on the size of your shop, 8.2GB may not be big. Ours is currently 21GB.Steve
2004-11-01
I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.
2004-10-22
Hi All, I need to query a Column of a table based on its ordinal position from a single select statement Here is my select statement Select col_name(object_id('TABLENAME'),13) from TABLENAME.The result is obivious that it returns the actual columnname. Question is How to query the column that is returned from the function col_name in one […]
2004-10-20
3 reads
Hans, I would install Win2K only if the final place where the database will be running is Win2K. As far as detaching from SQL2K to SQL7 system make sure that the database is in 7.0 compatability prior to detaching from SQL2K. Also, you need to make sure beforehand there is no code that takes advantage […]
2004-10-19
You can join to a UDF that returns a table. You might need to adjust your UDF to suit - I assume that the parameter for this is currently the customerid. Have a look at the following - it might be something like what you are aftercreate table myCustomerTable (custid int, custname varchar (100)) goInsert […]
2004-10-14
Hi!Using my trusted login (it has sa privileges) I created new column (bit, allow NULLs) for a table. After that only me can see it and only with EM, even after reconnecting to the server. There is no any records for this column in syscolumns table.Wonder what had happen!?!Thanks.
2004-09-20
22 reads
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