When a database starts showing signs of an illness, it's up to the DBA to get to the root of the problem, fast. Kat Hicks takes a look at the most common causes of database troubles, free tools that can help, and the misconceptions that get in the way.
2013-04-22
4,265 reads
2011-07-11 (first published: 2011-07-02)
1,947 reads
Diagnostic report pack for SSRS that provides monitoring capabilities for all items on the Report Server.
2010-02-04
14,241 reads
I have an aplication written in VC 6.0 that uses ODBC API 3.0 with connection pooling activated. I execute a STATEMENTlike this pStatement = (SQLCHAR *) "{call MyProc(?,?)}"; rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR, lstrlen(pParam1)+1, 0,pParam1, 0, &cbNTS); if(!MYSQLSUCCESS(rc)){error_out(0,0,hstmt);return false;} rc = SQLBindParameter(hstmt, 2, SQL_PARAM_OUTPUT, SQL_C_SLONG ,SQL_INTEGER, 4, 0, &i_NoOfRows, 4, &ii_NoOfRows); if(!MYSQLSUCCESS(rc)){error_out(0,0,hstmt);return false;} rc = SQLPrepare(hstmt,pStatement,strlen((char*) pStatement)); […]
2005-05-19
4 reads
Paul, nice job finding that link. Sadly it doesn't help because its for Server 2000 and I have Server 7.0 with SP4 already applied. I checked the registry settings and they appear correct. SQL Server 7.0 and SP4 have been reinstalled twice.Thanks, - David
2004-01-30
2 reads
I got the following error when I tried to connect: could not obtain the schema rowset for OLE DB provider 'UNKNOWN'. The Provider supports the interface, but returns a failure code when it is used
2003-08-12
2 reads
Homesite did go to Macromedia. I'll give Ultraedit a try and thanks for the notes on commenting in Edit Plus. Not as easy as a hot key, but pretty close. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-18
Frank, This may be what you are looking for: quote: Estimating the Size of a Table The following steps can be used to estimate the amount of space required to store the data in a table: Specify the number of rows present in the table: Number of rows in the table = Num_Rows If there […]
2003-07-14
3 reads
Makes sense, maybe we could offer a nice logo'd binder as an option. For ebooks where you're getting new content I think that makes sense, but would anyway want an ebook of material that was available free here, just a matter of getting it and organizing it? Or is it worth a few books for […]
2003-07-08
You might consider looking into using the DATAPART function and summing and averaging on the WEEK datepart. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-07-07
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