Viewing 15 posts - 1,141 through 1,155 (of 49,552 total)
sql_lock - Wednesday, July 12, 2017 7:13 AMYou can take COPY_ONLY backup as this does not break the log chain.
Wrong. Full backups,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2017 at 7:38 am
If you write a piece of data, then read it at any time after the write completed, you get back the data that you wrote.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2017 at 6:38 am
Oh, so just another column in the query?
SELECT CompanyName ,
SUM(TotalSales) AS TotalProductSales ,
SUM(TotalCost) AS TotalCost ,
SUM(TransCost)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2017 at 3:34 am
What exactly are you trying to do?
It's possible to get a value out of a procedure as an output parameter, but it's a single value. Resultsets, as you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2017 at 3:25 am
Row estimations are off by a large factor.
Can you try doing a stats update WITH FULLSCAN on the tables involved in that query?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 2:53 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 2:44 pm
gailcole - Tuesday, July 11, 2017 2:22 PMit should be 1900-01-02 24:01:00.000
That's not a valid time though. A clock's not going to show...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 2:40 pm
Thom A - Tuesday, July 11, 2017 10:02 AMThe text data type has been deprecated since 2008.
Since 2005.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 1:48 pm
Licensing is about paperwork. You need to have bought enough CALs for your users and have the paperwork to prove it when you get audited. They aren't objects that you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 1:47 pm
You don't run database files. You attach them to a SQL instance.
What is the exact problem you're having, what errors are you getting?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 3:16 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2017 at 1:44 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2017 at 4:12 pm
The u.last_logged_in is NULL for all those cases.
NULL never returns true in any comparison (other than IS (NOT) NULL), and so the ELSE branch of the case...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2017 at 10:11 am
You can't move files or filegroups from one database to another, if that's what you were thinking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2017 at 9:29 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2017 at 8:29 am
Viewing 15 posts - 1,141 through 1,155 (of 49,552 total)