2009-07-23 (first published: 2009-07-13)
1,374 reads
Database Recovery
Find Database Recovery Mode
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
1,979 reads
RE: HOT TIP on posting!!!!!!!
The SHIFT-return thing also works in many word processors including Microsoft Word.
2004-04-07
RE: Backup and Restore on different systems.
In my experience, the file you're restoring FROM has to be on the same server as the database you're restoring. SQL restore only "sees" what is on its own box.
2004-04-07
RE: re-index
To quote : "SQL Server knows statistical information about your data through a special object in the database (which I refer to as the statistics blob). The statistics blob contains information about how the data is distributed throughout the table and also calculates the average number of duplicates for the indexed columns. When you create […]
2003-07-22
1 reads
RE: Service Accnt Passwd Changed.. Server not Starting
From the Server, go into control panel ,then administration (if win2k), then servers. Find the sql server service and change the password there.
2003-06-19
1 reads
RE: cast varchar as datetime
It can be done. I trimmed off the 'FRI' part and it converted. I used a substring. Patrick
2003-05-15
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers