I want to plot a chart reconstructing the frequency of record saves from a history table. In the history table I create a new record (with savedatetime) for every save that is made. For this I need to place a count of saves made in every 10 minute interval. Importantly I need missing intervals to […]
2001-11-05
Comments posted to this topic are about the content posted at http://www.sqlserver.superexpert.com
2001-11-02
1 reads
DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.
2005-07-01 (first published: 2001-11-01)
37,334 reads
I am running SQL 7.0 and have recently started experiencing problems with Full Text Catalogs getting lost after I reboot the server. This has happened the last 3xs I've rebooted the server. I can see the physical fold and files in their proper directory and it doesn't look like any of their file names have […]
2001-10-29
Hi, it seems to me that OLAP/DTS is probably the most interesting technical area for SQL DBAs to get involved in - if you can! Unfortunately in my company they have no current plans to implement it, although there is a constant need for standard database design and stored proc scripting. Is this a common […]
2001-10-29
3 reads
Hello, I am designing a Database. I want to ensure all validations happen at the client and also at the server end. My client validations in Javascript are done. Now I am looking at the server side validations. The best place to put them were in Rules/Constraints. But the problem that I face is that […]
2001-10-28
4 reads
Ok. This is my first time working with OLAP. One of developers says that he has to be OLAP administrator to work with cubes. The database that he's working on has sensitive data (ok, what database doesn't have sensitive data). If I give him OLAP administrator rights does that only give him Administrator anything like […]
2001-10-26
48 reads
I want to have the recordset from a stored procedure. I am using the following query select * from openquery(server2 , 'server2.esop_softdel.dbo.sp_sel_summary @EmployeeID="0000000001", @CompanyID="0000000001"') My stored procedure is using a temp. table #sumarry. If i execute the above query I am getting the following err: I am not able to find out what the error […]
2001-10-25
2 reads
2001-10-24
Comments posted to this topic are about the content posted at http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
2001-10-24
1 reads
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