Viewing 15 posts - 1 through 15 (of 53 total)
I'm sorry to haven't answer, neither updated the script for so long. My appologises.
First of all, I've made a new version of the script, creating a stored procedure and adding...
October 17, 2012 at 1:23 am
I found that this script doesn't write down schema permissions.
You might check the following: http://www.sqlservercentral.com/scripts/Security/71562/
February 6, 2012 at 9:10 am
I'm also looking for a comparative between theses products
May 5, 2011 at 1:05 am
Thank you for this post! I like the way you give the multiple alternatives, pros and cons 🙂
March 24, 2011 at 3:59 am
I don't like prefix on tables. But now I'm creating a new database and I'm defining the "naming convention". Developers have asked me that they would like to know which...
July 27, 2010 at 6:02 am
As you said in the article, enable xp_cmdshell is not the best option and a solution would be to create a CLR function to get the uptime.
But, as the uptime...
June 23, 2010 at 3:14 am
Thank you Paul!
You post it just when I needed to use the CROSS APPLY to process a XML file 🙂
April 20, 2010 at 2:00 am
Kevin and Andy,
I wouldn't like to be missunderstood: I absolutely agree with you. I only use dynamic sql when I cannot avoid it, as a last option. It has so...
February 18, 2010 at 9:32 am
I've written a way without using cursors, neither temporary tables.
I'm using dynamic sql.
But in this case I would use a variable table (similar as the link you posted) because the...
February 18, 2010 at 8:58 am
That editorial fits perfectly in a question I wanted to post in the forums: what books do you recommend to learn all the BI environtment (SSAS, SSRS, SSIS, DataWarehouse, etc...)...
January 13, 2010 at 2:28 am
How many times do you have to debug using these indexes?
An easy (but ugly) solution if it happends very few times you could create the index on the database when...
January 4, 2010 at 3:47 am
Anders Pedersen (12/4/2009)
I don't have that situation here, I would just transfer the data directly from SQL to SQL. The solution should be obvious! ImportFromExcel.DLL !!! Get...
December 4, 2009 at 7:22 am
I like this way to export to Excel (in SpreadsheetML format). It's very fast. But then I need to import back the Excel file to SQL Server and here is...
December 4, 2009 at 4:36 am
Rob Fisk (12/2/2009)
December 2, 2009 at 6:06 am
It has happened again and this time I could start checking what was going on 🙂
The first problem was connecting to database: I couldn't log into because I got error...
May 14, 2009 at 3:13 am