Viewing 15 posts - 1 through 15 (of 37 total)
Also, while we are here...
Script to insert the encrypted data
Open Symmetric Key ....
Insert Statement
Close Symmetric Key
The script runs fine even when I don't close the symmetric key. What's the purpose...
January 9, 2010 at 11:29 am
Every DBA job is different to some extent, but the majority of the skills, in my opinion, are transferable.
They must have found out what you are capable of through...
January 9, 2010 at 10:41 am
Read their standards and documentation to get an idea what is expecting you.
January 9, 2010 at 8:44 am
If the data is static (won't be modified) than why not?
If you don't query that data a lot, then move it to a cheaper storage and use current storage...
January 6, 2010 at 1:33 pm
Thank you GilaMonster, this makes perfect sense!
Alter table statement has worked from the start, I was after the statement that I could include after the column definitions.
Thank you very much,...
January 6, 2010 at 1:06 pm
Hi,
Thank you for your reply, but I'm looking for a seperate constraint which I can place after my column definitions.
E.g.
Col1 Integer,
Col2 VarChar(20)
-- PK:...
January 6, 2010 at 12:50 pm
Hi,
Do not combine the data into 1 column, you'll break the first normal form and this beats the entire purpose of the database.
I would start by analysing the first two...
January 6, 2010 at 12:48 pm
Hi again,yes - 25mb is a very rough estimate.my assumption is that your database is below 500mb in size.I have seen aspstate database with 8mb Mdf file and 20gb Ldf...
January 5, 2010 at 2:52 pm
When box with SQL server dies,your backups will die. In ssms press f1 and in help window look for BACKUP DATABASE statement.
Ideally I would have production server and its...
January 5, 2010 at 2:47 pm
Hi,
I would turn off 6 gb limit since 1 day it might crash horribly.work on a new process to assess the growth.10% in my opinion should be changed to size...
January 5, 2010 at 2:41 pm
Can you give us example of checks that you are carrying out?basic checks should be enforced through CHECK,unique,null or not null,data type etc.
Everything else I would validate through front end.but...
January 5, 2010 at 2:37 pm
I have read the article on MSSQL Tips website.
The system views do provide useful information about the backups.
In my opinion, the following things are missing:
1. In their example, you...
January 5, 2010 at 11:26 am
Can you please give the example or tell us what we should be JOINing on?
January 5, 2010 at 10:22 am
Store table in a seperate file group and take a backup of that file group?
January 5, 2010 at 7:32 am
Can you describe what you are trying to do? Quite a lot of the times the cursors can be avoided...
January 5, 2010 at 7:25 am
Viewing 15 posts - 1 through 15 (of 37 total)