This class was created by Brainscape user Cody Smith. Visit their profile to learn more about the creator.
By:
Cody Smith
- decks
- flashcards
- learners
Decks in this class (22)
Temporary Tables and Table Variables
Create a temporary table based on...,
Does a temporary table exist afte...,
Find the name of a temporary tabl...
58
cards
Exercises
Create a computed column in a table,
Alter an existing computed column...,
Create a filegroup
12
cards
Table Partitions
How is data partitioned in a table,
Does the partition key column hav...,
What is the best column to use wh...
19
cards
In Memory OLTP Tables & Natively Compiles SPs
When is it beneficial to use an i...,
When is it beneficial to use a na...,
Do in memory oltp tables have pages
16
cards
Database Collation
Ci cs,
Ai as,
Sc
9
cards
Columnstores and Sparse Columns
What are columnstore indexes used...,
What is a column store,
What is a rowgroup
19
cards
Data Control Language Statements
What is the statement to give acc...,
What is the statement to remove a...,
What is the statement to make sur...
3
cards
Execute As
Why use execute as,
What is the syntax to execute as,
What if you dont want the execute...
4
cards
Security
What is public key cryptography,
How do you set up sql server to u...,
What is a loginless user used for
20
cards
Design Locking and Granularity levels
What does lock escalation always ...,
What does lock escalation never e...,
What happens if a transaction att...
7
cards
Indexes
How do you force the system to us...
1
cards
Database Normalization
1nf,
2nf,
3nf
11
cards
Database Performance
Performance counter acceptance ov...,
Performance counter acceptance ov...,
Performance counter acceptance ov...
10
cards
CLR
What are the permissions you can ...,
What is safe permission_set,
What is external_access permissio...
7
cards
Index Creation Errors and Deterministic Functions
Can an index be created on a comp...,
Can an index be created on a comp...,
What is the only string function ...
3
cards
Extra Notes
What is the difference in creatin...,
What is the suitable fillfactor s...,
When should you use pad_index off
18
cards
Extra Notes 2
What is necessary to be able to c...,
What are the steps in order to cr...,
What datatype is generated with e...
12
cards
Extra notes 3
How can you use a symmetric key a...,
Can a scalar user defined functio...,
What monitoring application would...
25
cards
Hash Indexes
Where are hash indexes used,
What is a hash index,
How does a hash index work
16
cards
Query Hints
With nowait,
With paglockx,
With readpast
10
cards
Log backups
Backup log database to device no ...,
Backup log database to device wit...,
Backup log database to device wit...
8
cards
Partitioned Views
What is a partitioned view,
What version of sql server is tab...,
What can be done in standard edit...
13
cards
More about
70-464 Certification
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cody Smith's 70-464 Certification flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
MCSA 70-740
- 4 decks
- 220 flashcards
- 157 learners
Decks:
1 Install Windows Server In Host And Com, 2 Implement Storage Solutions, 3 Implement Hyper V, And more!
Flight Paramedic Certification
- 15 decks
- 946 flashcards
- 1612 learners
Decks:
Respiratory, Pediatrics, High Risk Ob, And more!
