2007-09-27
4 reads
Scripts
2007-09-23
4 reads
2006-01-30
1 reads
RE: sysjobs/jobhsitory meaningless run_time and run_Duration
You could probably find this information in the Windows event log, if you are logging informational messages.
2005-03-15
RE: How to get around error 8152?
You can check the datatype returned from the substring by executing a short SELECT ... INTO test.SELECT TOP 10 field1, field2, SUBSTRING(period,2,2) AS PERIOD, field4 into TestTable FROM BaseTableYou'll probably need to cast the substring into a varchar.
2005-03-14
SQL Server Recovery by Reassigning SAN disk resources
Has anyone successfully transferred San disk resources from one cluster to another. Our test failed this weekend. Part of our procedure was to change the disk signature of the SAN disk resources to matche what the target server had with its current San disk resources. The rename removed the disk from the cluster resources while the […]
2005-02-01
7 reads
2004-09-22
Custom Log Shipping
My customer needed a second machine running SQL Server with a copy of his database in read only mode. The 2 servers are not in the same LAN. They are connected via a slow WAN connection. The basic requirement is that the second server comes in synch with the first every 24 hours.We started with a full backup on the first server and […]
2004-08-13
1 reads
RE: Memory configuration
From BOL."When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical memory available. SQL Server grows or shrinks the buffer cache to keep free physical memory between 4 MB and 10 MB depending on server activity. This prevents Microsoft Windows NT 4.0 or Windows 2000 from […]
2004-02-24
RE: Problem with "Ingore duplicates" index option
I agree that it's not a good idea to turn on the "ignore duplicate" option, however, I was just using this feature temporarily as a simple way to insert unique records (weeding out duplicate records). Basically, I'm just trying to understand the way this feature works. I know that you can write an INSERT the way you […]
2004-02-02
1 reads
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