Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.
2009-01-19 (first published: 2008-08-01)
2,458 reads
2008-05-13
8,085 reads
Hey Steve, is it possible to have the nightmare stories back up on the site someday? I'd like to reread some of those..
2005-05-27
It looks like you have different collations between server A and B or between the databases/columns on A and B. Maybe you can try moving data using a SELECT query with the collate parameter.
2005-04-26
By the way if you are going to use above query just make sure you set up a constraint on EmpID and Date (To avoid the asumtion that the query is making about not having duplicates and guarantee data quality as well )
2005-04-26
SQL doesnot allow you to use derived column names in the where clause. You will have to repeat the formula in the where clause
2004-12-14
Had this problem and it turned out that the network folder had write permissions but not create. I had the network admin add create/full permissions explicitly to the DBA group and it worked fine.
2004-08-12
Backup/Restore should have no problem moving databases between servers. How far are you getting when you try this method?
2004-07-21
2004-07-20
Hi,I need a solution as to how and where I have to Install Reporting Services.I have 3 servers. Server 1 is the web server which is has public access. Server 2 is the backend sql server which is behind firewall. Server 3 is backend server with IIS behind firewall.I have developed reports which should be […]
2004-07-07
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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