SQL Server consolidation: Why it's an optimization
SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.
2008-10-16
2,737 reads
Licensing
Compliance
Complying with software licensing is something you should do, but how far should companies take this?
2007-12-24
130 reads
RE: Restore failure
There were definitely no threads into the database. What I did was to fix this was shut down the services, copied the .mdf and.ldf from the production box and restarted the services. I then did a restore over it with out issue. Weird!
2004-09-09
RE: how to configure sql server 2000 and windows server 2000 in order to allow remote connection through vb
hello noeld, Thanks for your reply. I'm glad that you brought it up because I'm not really familiar with the client netweork utility, and it could be that this is where the answer to the problem lies. But before I do anything, I just wanted to ask you somethin gin that respect. If I have my ms […]
2004-02-25
RE: OS 3rd Party Backup Tool - Why Did This Work??
Hi,"you have the Agent for SQL installed and are using it."Agent, is different from MSSQLAgent? This agent is provided by Veritas? How can I verify this "agent" is running?
2004-02-25
RE: Transaction error when loading SQL table from linked server to Oracle DBase
Can you show your codes here?
2004-01-16
RE: Nov 21 - just wrong
I agree with the remark below. If you modify indexes, other queries may now perform poorly. It is just a tip of the iceberg. In theory, you have a primary key there for a reason. If the question had given more information as to the purpose of the primary key, then a better decision to […]
2003-11-21
RE: BULK INSERT & Text Qualifier
I've had to figure this out in the past. Here's what you need to do, using your example. "datahere","data with a comma, more","xxx" FMT file: 7.0 3 1 SQLCHAR 0 10 "\",\"" 1 DataHereColumn 2 SQLCHAR 0 30 "\",\"" 2 DataWithCommaColumn 3 SQLCHAR 0 3 "\"\r\n" 3 xxxColumn Using \",\" will treat the "," as […]
2003-11-18
RE: A way to prevent users from using QA or EM?
Actually I found something while cleaning up my archive, that mentioned this way, but my finger was quicker and I deleted the row Anyway, lots of different approaches came up. Frank
2003-09-05
2 reads
RE: SQL Server grinds to a halt
I suggest starting with a regularly scheduled profiler trace, capturing Batch and RPC Completion events and certainly the database amongst the columns. You could have it scheduled for several times a day, running for say 5 mins and a maximum of 1mb output file. The output file name should be constructed from the current date/time. […]
2003-07-28
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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