The tool is not for free, I can't afford for it to be. This is my full-time job so as my wife and children cannot live on air - I have to charge for my services which have an excellent return on investment I might add.What a suprise, Mark! No offense, but I have a […]
2004-12-20
Comments posted to this topic are about the Question of the Day for 21 Dec 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=414.
2004-12-18
Hi,Just wondering if anyone has good acceptable values for the thresholds for these sql counters:Page Faults/sec Pages/secThanks in advance
2004-12-17
256 reads
2004-12-16
The base table names are sysibm.systables and sysibm.syscolumns, but IBM recommends you use the catalog views - syscat.tables and syscat.columns.
2004-12-02
1 reads
It is actually not the best idea to name columns with reserved words. You should really change this.
2004-12-02
I have inherited 2 (interface) servers that use SQL Server connectivity and tools only - no DBs. They were upgraded from SQL 7 to 2000, but now both servers have both versions. I have been asked to remove the SQL 7 files.Is it possible to just remove SQL 7 without affecting SQL 2000?Can this be […]
2004-11-29
2 reads
I want to give my developer access to one of the store Procedure, the store procedure has an update and insert activity.when I give him execute permission on that store procedure I am getting Error you don't have privileges on Insert and update.Its SQL Authentication, is any way where I can avoid giving him access […]
2004-11-29
I am looking for checking index when exists with sane defination. some thing in this line:alter procedure usp_check_index_object @Objname varchar(1000), @indexName varchar(8000), @decKeys varchar(4000), @decFillFactor int as declare @indid smallint, -- @objname nvarchar(1000), --776 @i int, @thiskey sysname, @keys nvarchar(4000), --2078 @objid int, -- @indexName varchar(8000), @OrgFillFact intselect @objid = object_id(@objname)--set @indid = 8 Select […]
2004-11-22
Merge replication keeps track of changes to published tables (articles) through metadata tables (triggers are created on each article and help to keep track of the changes you do). As you keep doing changes those tables will continue to increase. The tables I mention are MSmerge_contents, MSmerge_tombstone to mention just the most important ones.Merge replication […]
2004-11-13
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers