Viewing 15 posts - 1,141 through 1,155 (of 49,571 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,...
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.
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)...
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...
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?
July 11, 2017 at 2:53 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...
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.
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...
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?
July 11, 2017 at 3:16 am
July 11, 2017 at 1:44 am
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...
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.
July 10, 2017 at 9:29 am
July 10, 2017 at 8:29 am
Viewing 15 posts - 1,141 through 1,155 (of 49,571 total)