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
Spatial
RE: A future for stored procedures?
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
RE: SQL Backup & Third party backup software
#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
RE: splitting 1 field into multiple fields
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
RE: Lookup Table Design
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
RE: Port 1433 and 1434 Blocked
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
data in table from 1 db to another-same server
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
RE: Executing SQL Command???
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
RE: Merge replication error, foreign keys
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
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