Forum Replies Created
Viewing 15 posts - 1,456 through 1,470 (of 49,571 total)
-
RE: Downgrading database from SQL Server 2016 to SQL Server 2012
SSIS and bcp/bulk insert should be about the same speed, and faster than lots and lots of INSERT INTO statements, as they have the bulk-loading optimisations.
175GB isn't that...
-
RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.
Can you post the table definition (all of it)?
Do you have either of the ALLOW_SNAPSHOT_ISOLATION or READ_COMMITTED_SNAPSHOT_ISOLATION database settings on? -
RE: Downgrading database from SQL Server 2016 to SQL Server 2012
Don't script out the data. Script out the database structure, bcp (or SSIS) for the data.
-
RE: Choose the result NOT in a JOIN-query
larsp777se - Monday, May 8, 2017 11:51 PMRE: Index_ID of the PK in In-Memory-Tables
Query returns 2 rows on SQL 2016 SP1
Plus, the title for the question is misleading. Afaik, there's no guarantee that if there are multiple indexes created on...
RE: Choose the result NOT in a JOIN-query
WHERE Registrations.CourseId NOT IN (
SELECT Registrations.StudentIdIs that ever going to work?
That's like saying "Give me all the employees...
RE: Choose the result NOT in a JOIN-query
larsp777se - Sunday, May 7, 2017 2:21 AMRE: Are the posted questions getting worse?
jonathan.crawford - Friday, May 5, 2017 7:41 AMRE: How to convert string to "data type" ?
Seriously, avoid this kind of design. It smells like an EAV table, and those are so hard to work with and perform terribly. I've seen them far too often, and...
RE: Why would SQL throw a Severity 016 alert?? following a successful db restore?
Use the GUI, script out the command instead of running it, cancel the gui.
RE: Why would SQL throw a Severity 016 alert?? following a successful db restore?
What's the exact command that you're running for the restore?
RE: Why can't I put database in READ_ONLY using SQLCMD from a remote Server?
To explain...
The NO_WAIT option on the ALTER DATABASE means that if the exclusive DB lock cannot be obtained immediately, the command should abort, not wait to try and...
RE: Query Completed with Errors but no error message
peter.adams 60541 - Friday, May 5, 2017 2:14 AMPlease note: 5 year old thread.
RE: How to build a field name in a select statement
anthony.green - Friday, May 5, 2017 2:52 AMRE: Choose the result NOT in a JOIN-query
Roughly:
SELECT whatever you need FROM Courses WHERE CourseID NOT IN (Select the courseIDs from Registrations for that student)
Viewing 15 posts - 1,456 through 1,470 (of 49,571 total)
