Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
2015-06-15
3,457 reads
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
2015-06-15
3,457 reads
Does Bruce Powell not realise that cursors are slow only when compared with set based SQL statements? They are probably quick compare with running the loop over a client recordset. Also Bruce should remember that source code control is not limited to C# etc. In my last 2 projects we used VSS for all sprocs […]
2004-08-18
2004-07-31
234 reads
#1 SQL Server Backup commands work. They will ALWAYS work with SQL Server. PERIOD.#2 There is 3rd Party backup software that works just fine (for now) with SQL Server. They may continue to work when there are changes/upgrades to SQL Server - but they may not. Do you want to take the chance?#3 I know this […]
2004-07-29
Just a comment on the subject of name parsing. The last word in the string is not necessarily the surname. For example, the surname "Saint Raymond" is 2 words. Also, the first word is not necessarily the entire first name. My friends "first name" is "Mary Dee". As someone who constantly gets sorted into the […]
2004-07-28
Ok, I am sorry - not really - but this is design madness. Seperate tables for each lookup table. Surrogate int keys when appropriate (almost always). This keeps referential integrity possible - hello thats the point of a relational database.ISO codes - give them a column with a unique constraint.Never, never, never design anything that […]
2004-07-27
Thanks Brian. I downloaded Microsoft's .NET based SQL Web Data Administration Tool. It allowed me to see the databases but gives me a server.timeout when I try to view the contents (tables). Doesn't life just make you wanna cry sometimes?
2004-07-27
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-07-26
Hi,Try the code given below.DECLARE @filterCriteria varchar DECLARE @filterCMD varchar declare @sql1 nvarchar(200) set @filterCriteria = 'w' IF @filterCriteria LIKE 'W' set @filterCMD=' DESCRIP LIKE ''%closed%'' or DESCRIP LIKE ''%deny%'' or DESCRIP like ''%withdrawn%'' ' set @sql1='select accountID from TEMP_TABLE WHERE ' + @filterCMD exec sp_executesql @sql1Hope this solves the issue.Nivedita Sundar.N
2004-07-23
Was a new snapshot recently generated which included object changes? If so, and the snapshot is being applied then:When subscribers are set up their either already have the schema and data, or the schema is pushed to them "yes, initialize the schema and data". If when the subscription is set up the "yes, initialize the […]
2004-07-22
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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