sql server 2019

Article

The announcement of the next version of SQL Server excites Steve.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-09-25

315 reads

Discuss

RS Internal Error !

by TeeGee

Brent Ozar Unlimited Blog

Topic

I use Reporting Services to provide my users with parameterised reports specific to their department. I have set up a simple system whereby all users have access to all reports (no custom roles). Windows authentication is used for report access and I have a windows group with appropriate rights assigned to browser role.Now here's the […]

2005-05-29

6 reads

Nested JOIN''s behavior

by Cris-Benge

SQLServerCentral.com

Topic

Hey all, got a query here that was reverse ported out of an Oracle app before I arrived out on customer site and the structure leads me to believe it's behaving more like a nested subquery arrangment than straight-forward joins. Here's an idea of how it is structured:select <RETURN LIST> from Table1 t1 inner join Table2 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-27

1 reads

RE: help with date parameters

by ron-k

SimpleTalk

Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.For more info on how to work with sql server dates you might want to look at these articles: http://www.sql-server-performance.com/fk_datetime.asp http://www.karaszi.com/SQLServer/info_datetime.asp

2005-05-25

RE: SQL Optimisation Vs Disk Defrag?

by David Poole

Database Journal

I would be extremely suprised to find that Windows defrag and Diskeeper were the same product. No-one would willingly buy a product that was as bad as Windows defrag.

2005-05-24

RE: GROUP BY problem

by Tassilo-Burger

Database Journal

Hi Rob,just to let you know. I adjusted your SP for my needs and found out following:Ok, I didn't mentioned that I can have also day 0 (zero); because of that I had to bring in a isnull function. (See first statement for first where clausel)select h_min.hotel_id, h_min.theday, h_max.theday - h_min.theday + 1 from hotels […]

2005-05-16

Question of the Day for 30 May 2005

by Site Owners

Database Journal

Topic

Comments posted to this topic are about the Question of the Day for 30 May 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=521.

2005-05-11

1 reads