I know this response is six years too late, but....

I cannot speak to SQL 2008 R2 or earlier, but SQL Server 2012 and newer can split a range...

Usually multiplying by 1. or 1.0 is a shortcut to cast from integer to decimal based on datatype precedence. This is what is being done in the latter example: RANK()...

I think I figured it out with the help of this reference:

http://sqlblog.com/blogs/tibor_karaszi/archive/2009/09/19/sql-server-agent-jobs-and-user-contexts.aspx

Looks like the original and effective logons from the job are the service account, but the effective...

Great ideas in the post!

What I would really like to see and still don't understand why it is not part of the SQL Server: full regular expression support. Regular expressions...

Thanks SoHelpMeCodd! I'll review your response once I'm back in the office next week. Till then Happy New Year!!

What about using TABLEDIFF.exe? BOL: http://msdn.microsoft.com/en-us/library/ms162843.aspx

The necessary command and parameters can easily be created programmatically with a simple T-SQL script. TABLEDIFF can also generate the statements to bring...

Taking this one step further to investigate 'safe' ad-hoc queries that are eligible for auto-parameterization. Add on to the predicate as necessary to either eliminate or include other plans in...

Does your SQL Server suffer from Premature Optimization?? There is a drug SQLialis that helps with this!!

Joking aside...excellent article Gail. Thank you for another excellent contribution of your knowledge...

Kudos to an awesome use of XE!

I too have experienced this error from time to time in an SSAS job and I do not accept the 'There is no real solution for this error.' solution. Why...

Right on chiesa.alberto. I was going to make the same suggestion. Itzik Ben-Gan's books are exceptionally informative and I highly recommend using them.

Here is a list of his books (or...

Interesting idea to use XML as a means of passing the parameters, could certainly be very practical.

I am interested in the blanket statement: 'dynamic SQL is a bad idea'? Yes,...

Technically speaking the answer to the question should be 'None of the above', sys.server_principals is NOT a DMV, it is Catalog View.

I did just happen to notice this:

http://www.sqlservercentral.com/blogs/salvoz-sql/2013/08/07/ssrs-report-actions-url-actions-and-sharepoint/

Doesn't directly apply to moving from Integrated to Native mode, but I wonder if some of the information may be helpful concerning...

I haven't had to go from to the other. From MSDN it doesn't look like this possible:

http://technet.microsoft.com/en-us/library/bb326407(v=sql.105).aspx

Anybody have any experience to the contrary?