RE: best way to copy database from one server to another?
Backup/Restore should have no problem moving databases between servers. How far are you getting when you try this method?
2004-07-21
UNPIVOT
RE: char varchar
Problem with CHAR is not ony disk space.You cannot add anything to the right of CHAR value, you must RTRIM it first.Try to do this:declare @T TABLE ( A char (5), B varchar(5)   insert into @T select 'A', 'B'update @T SET A = '_'+A update @T SET A = A + '_'select * from @Tupdate @T SET B […]
2004-07-08
RE: Question of the Day for 18 Jun 2004
Was no-one taught BODMAS at school?Order of calculation is Brackets, Division, Multiplication, Addition, Subtraction. Can't remember what the 'O' stands for!!!
2004-06-18
2 reads
Problem with the Test
I didn't know where to put this but i got this error at the end of the Security testTotal Questions : ADODB.Field error '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /testcenter/TestGrade.asp, line 0 I couldn't get my grade so i don't know […]
2004-05-21
CAN SOMEONE EXPLAIN TLOG MECHANICS (GROWTH, SHRINKAGE) ???
I know this is an oft-discussed topic. My issue is that through all the MSDN articles, KB searchs, forum discussions, books, expert pontifications, etc. No one seems to really fully disclose how the Tlog actually works.For instance, I'm running a FULL recovery model on my databases. So I expect to see mammoth log files.But, depending […]
2004-03-25
RE: How to restore Transaction log file using Query Analyzer.
Yes.Transaction log backup is of everything since the last backup of any type.Differential backup is of everything since the last FULL backup.Scenerio: Midnight - Full Backup, every 10 Minutes a Transaction Log (TL) backup, every hour a Differential (Diff) backup.Now at 1 PM your database crashes. You COULD restore the Full backup and every TL […]
2004-03-19
RE: Securing a Payroll Database
Something more.Patch upadte.Run SQL Server service as local sysytem a/c.Disable MSDTC if you don't need it. Disable the Windows guest account. · Rename the administrator account. · Enforce strong password policy. Enable C2 audit.Protect your database backup.Verify Everyone Group Does Not Have Permissions for SQL Server FilesEncrypt your data files using Encrypting File System (EFS). · Restrict […]
2004-02-11
1 reads
RE: Passing Parameters to trigger
Not a pretty solution, but I have seen SPs and Applications that pass information to triggers through CONTEXT_INFO (See "Session Context Information" in BOL) Cheers, - Mark
2003-12-15
1 reads
2003-06-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers