Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,150 reads
Naming convention
RE: Bulk Insert And Table Data Type
thanks a lot tomash I will use temp tables instead of table data types
2004-01-29
1 reads
RE: MS SQL 64 bit on Opteron
Looking BOL for SQL2000 64bit, they only mention Itanium/Itanium II processors. I know this doesn't really help you, but it doesn't look good. There's no HCL 64bit SQL either..
2003-07-24
1 reads
RE: Bad practices
Not sure I agree about the locking mechanism being a bad practice. Most modern apps are designed to work without a constant connection (very optimistic locking), so there is no way for SQL to hold the lock. SQL locks are for data integrity, application locks are often more for business rules. I know they sound […]
2003-07-23
1 reads
RE: Need a little course in ASP
Frank, To change the loggin location Right click on the website > Properties > Enable Loggin > Properties > change the location at the bottom. Assuming you using IIS5+ Can't remember anything about the earlier versions of IIS I like that script on how to import them. Simple but you could create some nice reports. […]
2003-07-14
RE: Need a little course in ASP
Crispin, that's very naughty Oh, and I think you just need to log the time as the last command of every ASP page. (trapping between the first and last commands just tells you how long the asp code took to execute). I think what Crispin means is you deduce the time spent on the previous […]
2003-07-14
RE: re-index and database size
Is it possible, the initial fillfactor was 90 and now you are doing it for 80 ? Is the total size of db same between prod and devl?
2003-07-10
RE: How many records can SQL Server handle?
Hi Kent, quote: If you have access to SQL Server Books OnLine, in the index search for: limitations-SQL Server objects that was the page I've meant. Thanks for waking me up! Cheers, Frank
2003-07-09
1 reads
RE: Moving entire SQL content to new server.
It sounds to me like you are trying to clone a server. I think the quickest, easiest way to migrate the whole server is to do the following: This is assuming that the new server has all the same drive letters/paths as the old one. Stop the SQL Server Service on both machines. Copy all […]
2003-07-08
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
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