Welcome to Sign in | Join | Help

iulie 2012 - Posts

I'm not sure how many full-text search over filetable demos I've seen (including some I've written that I was just perusing), that do something like this. CREATE TABLE foo AS FILETABLE WITH (FILETABLE_DIRECTORY = N'ftdir'); CREATE Read More...
I noticed that my database log file has grown to 200Gb. I tried to shrink it but is still 200Gb. How can I shrink the log and reduce the file size? The problem is that even after you discover about DBCC SHRINKFILE and attempt to reduce the log size, the Read More...
A number of months ago, I wrote an article using the SQL Server filestream feature programmatically. I've gotten a number of inquiries since from folks who *need* to login to SQL Server using SQL logins (often the same SQL login for everyone), but Read More...
Continued from the previous post, " Some new/upcoming Windows Azure SQL Database DMVs and diagnostics "... Read that one to find out who Vinod and Michal are. So, before you all run out and try it, this isn't working yet. But, like the WASD Read More...
I didn't get to a whole lot of others' sessions at TechEd this year, but was pleasantly surprised by Vinod and Michal's session on "SQL Azure Administration and Application Self-Servicing". Although most of the really interesting Read More...
While preparing for my TechEd talk on filetables and full-text search, I came across this tidbit that I thought was interesting. With the advent of XML support in databases, specifically SQL Server's XML data type in SQL Server 2005, there has been Read More...