Viewing 15 posts - 1,876 through 1,890 (of 2,007 total)
since assignment of tasks frequently requires that "How" questions are frequently asked by the assignees.
If you are getting too many 'How' questions, then the company needs to harden...
October 17, 2011 at 3:26 am
Your boss shouldn't really run your schedule, but tracking down the things you spend time on and examining them later is a good way to see if you're working...
October 17, 2011 at 3:17 am
It's my checklist. Please feel free to add your points.
•Create a FULL backup of database.
•Create scripts for relevant Jobs, Logins etc
•Take database offline, for some time. (You will find that...
October 17, 2011 at 2:55 am
Thomas.s (10/17/2011)
What is the main use of creating role in sql server 2008
It's set of permissions. With roles you group related permissions and assign it to respective users.
For Example, you...
October 17, 2011 at 2:39 am
Cant you just create a DB snapshot ?
By the Database Snapshot definition, it's not applicable here.
A database snapshot is a read-only, static view of a SQL Server database (the source...
October 17, 2011 at 2:24 am
I am seeing a 50-80% reduction in backup size.
Few Facts about Backup Compression:
The compression ratio of a compressed backup depends on the data that has been compressed. A variety...
October 17, 2011 at 2:20 am
But the remote site will be taking a full backup each week as part of their normal backup and recovery procedure.
It was not mentioned in the opening post.
There aren't a...
October 17, 2011 at 2:13 am
thang_ngo_2002 (10/16/2011)
But I don't understand why when I create a new Transact-SQL endpoint, connect permissions for public are revoked for the default TDS endpoint and I have to...
October 17, 2011 at 1:56 am
I can't just copy the production database again because I removed some tables and added some indexes, new tables, stored procedures, etc.
If #<modified objects> is less than 5% (or...
October 17, 2011 at 1:41 am
15 reports
SSRS? It can be done at any Reporting Tool Administation.
If reports means SQL Scripts / Stored Procedures (I know GM will not dig into database, but in...
October 17, 2011 at 1:26 am
It would be good for you (in long run) to read and understand the DB Design concepts before throwing your issues (Professional / Academic) on forums.
First normal form (1NF)
Table faithfully...
October 17, 2011 at 1:18 am
I don't want to backup them, so to avoid any performance impact,
If it's just object definitions, scripting make sense else it (script for objects with data) would be...
October 17, 2011 at 1:01 am
Eskandari (10/15/2011)
RESTORE DATABASE MyDatabase
FROM DISK = N'C:\MyBackup.bak'
WITH
FILE = ?,
NOUNLOAD,
REPLACE,
STATS = 10
GO
because there are many backups...
October 15, 2011 at 6:54 am
Anand.A (10/15/2011)
i create 2user(A,B) this 2user having permission to access (C_db)
this C_db having 50 tables..
now my A user can access only 25 tables,B user can Access next 25 tables..
so...
October 15, 2011 at 1:48 am
Msg 2, Level 20, State 0, Line 0
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible....
October 15, 2011 at 1:42 am
Viewing 15 posts - 1,876 through 1,890 (of 2,007 total)