Since SSMS is designed to inherit that kind of thing from Windows, I think the only solution would be to run SSMS in a virtual computer, with the localization set...

Assuming "correct results" means dates between the two variable values, including the end-date value, then yes.

As mentioned, using <= @EndDate can give odd results.

For example:

DECLARE @T TABLE

...

I'm not entirely clear on what you're asking.

Do you need a way to monitor SQL Server memory use?

Or

Do you need a T-SQL script that will consume a huge amount of...

I don't think that's an issue with SQL Server. I think that's an issue with Management Studio. Is the workstation you're running queries on set to the proper...

paul.j.kemna (1/7/2013)

---

The actual syntax would be :

DECLARE @StartDate as date

SET @StartDate = some calculated date

DECLARE @EndDate as date

SET @EndDate = another calculated date

CONVERT([varchar](10), MyDatetimeColumn, 101) AS MyDate

...

WHERE MyDate >=...

There's a lot of data out there about how to build and maintain hierarchies in SQL Server.

First question is, are you using SQL 2008, as per the forum you posted...

There can be a couple of reasons to rebuild vs reorganize, but you're right that the most usual reason is fragmentation level.

Rebuilding also rebuilds stats, which is often a very...

Email on SQL 2005 and later is an asynchronous process. Even with a wrong address, that won't stop a job, it just enters an error in a log table...

I seem to remember being able to get Management Studio to connect to SQL 2000. I haven't administered an SQL 2000 server in a while, so I could be...

Eric M Russell (1/7/2013)

---

GSquared (1/7/2013)

---

Eric M Russell (1/7/2013)

---

Using the a VPN to connect to my desktop at the office, I don't even have any corporate email on my laptop, it...

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to tell, from what you wrote,...

Yes. It's development in production. It will bite you, sooner or later.

Develop on the dev machine. Get a copy of SQL Server Developer Edition ($43 on Amazon),...

If you mean something like:

WHERE MyDateTimeColumn >= CONVERT(VARCHAR(25), MyOtherDateTimeColumn, 101)

AND MyDateTimeColumn < CONVERT(VARCHAR(25), YetAnotherDateTimeColumn, 101)

Then, yes, that will work. It'll be inefficient, but it will work.

Fun.

We have a third party hosting solution for one of our production databases and our web servers. Because of non-standard backup retention policies designed by my predecessor, if I...

Eric M Russell (1/7/2013)

---

Using the a VPN to connect to my desktop at the office, I don't even have any corporate email on my laptop, it absolutely nothing work related...