The default rounding method in .NET is Round-to-Even (or 'Bankers Rounding' as described in this thread). This type of rounding can be implemented in SQL Server quickly, easily and accurately...

I agree that a little creative thinking is required.

The aspect that causes us a problem is the removal of the server/CAL licensing model from the Enterprise Edition. We have a...

aditya-457589 (6/21/2011)

---

create table TB (StartDate datetime, StartTime datetime, EndDate datetime, EndTime datetime)

declare @dt datetime , @time datetime

select * from TB

where StartDate < @dt

AND StartTime<...

Apparently Microsoft "strongly recommend that you set max degree of parallelism (MAXDOP) to 1 SQL Server instances that host SharePoint Server 2010 databases".

http://technet.microsoft.com/en-us/library/cc298801.aspx

I don't know whether or not...

A little more information wouldn't go amiss - which performance counter(s) are you monitoring?

Chris

Which tool are you using to see how much memory SQL Server is using?

Chris

The...

Just a reminder that in SQL Server 2008 onwards you can use the following to represent a binary value as a character string (rather than a CTE or sp_hexadecimal):

SELECT CONVERT(VARCHAR(12),...

lancebeacroft (3/28/2011)

---

Sorry, but I am not happy with this solution at all.

My view is that any changes to procedures must be auditable. therefore, first off I would have identified the...

Depends on the language settings. I get the following error:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

Serves me right for...

paul.knibbs (2/10/2011)

---

The table on the linked page raises a question. Pretty obviously support SQL Server 2005 with any service pack less than 4 expires in a few months, but it's...

I would be tempted to use Red-Gate SQL Compare to generate your script (you can download a trial at the link provided).

Use your database containing the tables and views as...

The following links will point you in the right direction:

CREATE LOGIN (Transact-SQL)

CREATE USER (Transact-SQL)

GRANT (Transact-SQL)

The links point to documentation for SQL Server 2008 R2, but the syntax for the tasks...

I would start by reading a blog post by Paul Randal regarding the 'one datafile per CPU' myth:

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.aspx

Chris

You may see an improvement by adding the OPTION (RECOMPILE) query hint to the problem query - this will cause the optimizer to recompile the statement with knowledge of the...