Viewing 15 posts - 7,336 through 7,350 (of 49,552 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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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.
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
November 10, 2014 at 9:13 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
November 10, 2014 at 9:07 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?
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
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...
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
November 8, 2014 at 10:29 pm
Take backup from SSMS
Copy backup file to other server
Restore backup.
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
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...
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
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...
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
November 7, 2014 at 10:46 pm
Are they causing TempDB to grow?
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
November 4, 2014 at 4:32 pm
Viewing 15 posts - 7,336 through 7,350 (of 49,552 total)