or you can try this. sp_msforeachtable @command1 = 'print ''?''' , @command2 = 'select count (*) from ?' sp_msforeachtable will perform up to three commands on each table in the database. When running, it replaces the ? with the name of the table.
2005-05-13
I, for one don't care what the iso standard says, they are wrong. A table does not represent a set of entities. Tables represent a single predicate function. So the Employee table with the following attributes:EmpNo, FirstName, LastName, DeptNo, Address,...MEANS literally "Employee (EmpNo) has a first name of (FirstName), a last name of (LastName), works […]
2005-04-06
It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake
2005-03-02
You have 2 pivots to perform. To translate Column names into data values, you can use a UNION query. This converts the In1, In2 and In3 column into values within a column named "In":Select ID, Month, 1 As In, In1 As Amount From YourTable Union Select ID, Month, 2 As In, In2 As Amount From […]
2005-02-02
Can't you just create a job, with DBCC CHECKDB('MYDB')?Make sure you create and output txt file to capture the output (on Advanced Tab)
2005-01-20
It can be done to mark a table as a system object but that requires going out of your way to upset the sysobjects table manually or use sp_MS_marksystemobject procedure which is not documented.You should be able to delete and recreate these tables but there are issues trying to change it back to a user […]
2005-01-12
Hi there.Well, I can't begin to try understanding what is going on, or the purpose of it all, however it seems like there's a lot of calculations, searched cases and stuff in there... Very briefly, I don't think that you can change the group by in any easy way... (At least not without further knowledge […]
2005-01-10
My Database hasn't been Defragged or Reindexed in over a year (maybe never) and it is timing out all over the place,so I really need to do this soon! I have been reading about indexes since the begining of the week (I knew nothing till then). I have also read almost everything on this site about them […]
2005-01-05
2 reads
Brian,Don't forget to turn on your pager after that.People who install SQL server with a blank password tend to use it in the applications for connection strings. Those applications will not be able to connect to the database after you change the password. Be prepared to explain things to them.Another thing: Some (me included) have their Enterprise […]
2005-01-05
I am trying to import a text file (a log file generated by another program) into SQL. The log file on the face of looks nicely formatted, however upon closer inspection, they are not tabs or spaces but multiple spaces! the number of spaces can differ widely depending on the first columns value. Thus when I […]
2005-01-04
76 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