Viewing 15 posts - 1 through 15 (of 7,182 total)
Calculate the minutes and seconds the same way you did the years, months and days - using DATEDIFF. Formatting of the type you describe is best done in the presentation...
August 26, 2021 at 8:30 am
Steve, what time zone will the PASS sessions take place in, please - Pacific Time?
August 20, 2021 at 8:42 am
This is also didn't work for me - it said the database was inaccessible. When I GRANTed CONNECT on the primary, it worked, though. I wasn't happy with that, so...
June 17, 2021 at 3:31 pm
Views don't take parameters, which I suspect is what @Table1 and @Table2 are in your example. You will need to write it as a function or a stored procedure instead. ...
November 19, 2020 at 4:17 pm
The tables in your query don't bear any relation to your sample data. And please use a universal format for dates, since I got a character conversion error when I...
October 20, 2020 at 1:15 pm
Sounds like you need database snapshots.
October 20, 2020 at 1:06 pm
Check this out. Since you're on SQL Server 2012, what you can audit may be restricted if you don't have Enterprise Edition.
October 16, 2020 at 10:08 am
If the estimated number of rows is high enough, then the query optimizer will judge that it's more efficient to scan the whole clustered index than it is do lookups...
October 14, 2020 at 10:20 am
What are you telling is just that in brentozar's script represent incorrect the result and I can asure you both querys return 20354 rows. Both querys...
October 14, 2020 at 9:57 am
In each plan, the estimated number of rows is wildly different from the actual number, which makes me think either that your statistics are out of date, or that you've...
October 14, 2020 at 8:52 am
August 26, 2020 at 4:13 pm
Check in Services to see which ones are running under system accounts. And remove NT AUTHORITY\SYSTEM from sysadmin so that this can't happen again.
August 26, 2020 at 3:11 pm
On the mobile version, there's a Search button (picture of a magnifying glass) right at the top of the screen.
July 27, 2020 at 11:06 am
There's nothing in the original question that suggests that any rules of normalisation or anything else are being broken. The question isn't about how you store the data, it's about...
July 16, 2020 at 8:21 am
Are you sure that is SQL Server code and not Oracle or some other RDBMS? This is a SQL Server site, so you're likely to get better help somewhere else.
July 15, 2020 at 4:09 pm