Viewing 15 posts - 7,336 through 7,350 (of 49,571 total)
Gary Varga (11/9/2014)
GilaMonster (11/7/2014)
DavidL (11/7/2014)
Can you explain further the idea of selling recordings of the sessions to attendees? Is it an additional fee over an above the conference fee?
Free...
November 11, 2014 at 12:00 pm
rrn 62873 (11/11/2014)
Hm, I thought keeping all the related backups in a single file would make things simpler.
Simpler to lose all your backups in one go, yes.
Backup production DBs to...
November 11, 2014 at 11:56 am
arrjay (11/11/2014)
I think we will start with all new tables should go into in-memory with the view of migrating the existing tables over time.
Are you intentionally trying to destroy...
November 11, 2014 at 11:54 am
Are you sure the sort is a problem?
There are two ways SQL can do a delete from an index. One is deleting row by row. This is incredibly slow on...
November 11, 2014 at 11:53 am
lol2k12 (11/11/2014)
one more question i need developer edition of sql server 2014?
You probably need one of the full production versions of SQL Server. Developer is allowed for development use...
November 11, 2014 at 11:52 am
You can't get the sa password. SQL passwords are stored using a one-way, irreversible hash. You can change it if you have a sysadmin login, but you cannot get out...
November 10, 2014 at 9:21 am
Encrypted data doesn't compress well, if at all. This is because the repeating patterns which compression takes advantage of aren't present once the data is encrypted. I doubt Red Gate's...
November 10, 2014 at 9:14 am
I wrote an article on this site on bulk-logged recovery. Google should turn the link up easily enough. Have a read through that, should answer most of your questions.
November 10, 2014 at 9:13 am
Runnable = waiting for a slot on the CPU. Suspended = waiting for a resource. Sleeping = have nothing to do.
High CPU usage outside of SQL?
November 8, 2014 at 10:30 pm
UPDATE dbo.Table1
SET colA = CASE ColC WHEN 'Yes' THEN (SELECT col1 FROM Table2 WHERE col10 = 'A') ELSE NULL END
,SET colB = CASE ColC WHEN 'Yes' THEN (SELECT col1 FROM...
November 8, 2014 at 10:29 pm
Take backup from SSMS
Copy backup file to other server
Restore backup.
November 8, 2014 at 10:39 am
It's a batch-terminating error. The ALTER TABLE error ends the batch immediately at the point it occurs (ends the batch, not the connection), hence it cannot be caught by a...
November 7, 2014 at 11:02 pm
DavidL (11/7/2014)
Can you explain further the idea of selling recordings of the sessions to attendees? Is it an additional fee over an above the conference fee?
Free for download for...
November 7, 2014 at 10:46 pm
Viewing 15 posts - 7,336 through 7,350 (of 49,571 total)