Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
569 reads
SQL Server 2008 R2
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
530 reads
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
586 reads
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
47,274 reads
RE: Trying to understand locking using SERIALIZABLE isolation level
I think I am sorted with this now anyway.Advice is - Keep transaction very short - Return server to default isolation level READ COMMITTED when on and on error found. - Consider using HOLDLOCK
2005-04-07
RE: Query Analyzer and sysdepends
well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always accurate. So I guess the worst that could happen is that you delete a proc that is actually needed but that sql server "said" it wasn't.
2005-02-21
RE: Question of the Day for 19 Oct 2004
I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.
2004-10-22
RE: Transferring Logins
The users within a database have a SID column which matches to the SID value of the login.If you transfer your logins first then restoring your database will maintain your user to login relationship.The sp_change_users_login procedure is great when autofixing a username that is identical to the login name but otherwise you have to know […]
2004-09-13
Dynamic SQL into stored proc ?
Hi,I need to write stored proc that will make a calculation taxes inside a table with several records. table will be created from the stored proc.Several users will execute from an application this stored proc and I create a table for each user. ( x.table1, y.table1, z.table1. ) with different results.How could I do this without use dynamic […]
2004-07-29
1 reads
RE: Execute stored proc fails from vb.net
Oops. I found the problem myself - persistence is the key. I omitted the "New" keyword when I declared the DataSet variable.
2004-06-11
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