Viewing 15 posts - 5,101 through 5,115 (of 49,552 total)
"Entry level" and "Internals" don't usually go together. Start with the basics (and there are many, many good books, go browse at Amazon and pick up a couple) and practice...
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
August 5, 2015 at 1:05 pm
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
And to get back on topic:
"What book...
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
August 5, 2015 at 12:18 pm
Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).
And to get back on topic:
"What book do I...
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
August 5, 2015 at 11:47 am
As is, it's impossible to answer.
Answering the question requires at minimum the query that the function is to be used with.
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
August 5, 2015 at 5:09 am
Restore they backed up primary and the archive filegroups as a new database, then if you need the data in the original database, copy it across.
Thinking about it some more,...
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
August 5, 2015 at 3:29 am
Please post the deadlock graph, the table definitions and the update statements.
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
August 5, 2015 at 2:43 am
Depends on how the query is run, can't answer that by looking at the function alone
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
August 5, 2015 at 2:38 am
All of them, and at least 5 years.
Seriously, there's no one book that's going to make you an expert. Read everything you can get your hands on. Test everything 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
August 4, 2015 at 2:53 am
Cases where it's acceptable to reinstall the server if the upgrade fails.
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
August 4, 2015 at 12:34 am
Well, yes. It'll be a stock, standard CREATE TABLE statement. As I said, you can't create the table from the execution of the procedure. You'll need to create the table...
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
August 3, 2015 at 1:12 pm
There's no easy way, and to be honest the hard way is not worth doing. Most people just use a value larger than 5. Some say 20, some say 30,...
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
August 3, 2015 at 1:09 pm
Backups don't take locks and aren't affected in any way by locks held by user queries.
Backup time is a factor of read time (IO throughput on the database files) and...
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
August 3, 2015 at 1:06 pm
You can't create the table with the execution of a proc. You'll need to first CREATE TABLE, and then INSERT INTO ... EXEC...
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
August 3, 2015 at 12:37 pm
You can't do that exactly. Best bet would probably be something like:
Take a backup of the primary filegroup and the archive filegroups (you need primary), put that backup onto archive...
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
August 3, 2015 at 12:29 pm
Start with Itzik Ben-Gan's book T-SQL Fundamentals. It's not a performance tuning book, but it'll give you a good grounding in writing T-SQL properly.
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
August 3, 2015 at 11:57 am
Viewing 15 posts - 5,101 through 5,115 (of 49,552 total)