|
|
-
Jacob Sebastian Commented 5 Months ago through Ask | 10 Points
I see no problem in automating such a process. In fact some of our applications do have weekly automated defrag jobs. It is also important to manually review the tables that builds a lot of fragmentation and there are chances that you fix the excessive ...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
Once you create an index on a view, your view is no more a virtual query/table. It will have its own copy of the data, which goes to the DEFAULT file group of the database (Unless you specify the desired file group when creating the index).
You can ...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
Does this help?
DECLARE @t TABLE (
data VARCHAR(20)
)
INSERT INTO @t (data)
SELECT '11:00 AM' UNION ALL
SELECT '12:00 PM' UNION ALL
SELECT '08:00 AM' UNION ALL
SELECT '09:00 PM' UNION ALL
SELECT '07:00 AM'
SELECT
data
FROM...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
If all the users and application subsystems are accessing the data through a single application server, a local cache at the application layer may help. However, that will be only for the read only data. If you want to allow the users to do data modific...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
See [this example][1] which demonstrates how to loop through each element within an XML document.
[1]: http://beyondrelational.com/modules/2/blogs/28/posts/10316/xquery-lab-35-how-to-write-a-loop-to-process-all-the-child-elements-of-an-xml-value....
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
Is it what you are looking for?
DECLARE
@Filename VARCHAR(100),
@UserName VARCHAR(100)
SELECT
@Filename = x.value('FileName[1]','VARCHAR(15)'),
@UserName = x.value('UserName[1]','VARCHAR(15)')
FROM @x.nodes('/xdp:xdp/xfa:dataset...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
You can use `SET DATEFORMAT DMY`, `SET DATEFORMAT MDY` etc to control the date format in the connection level. May be it will be helpful if you can share an example of the input data that gives you the error....
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
First of all, I edited your post because you posted a HUGE XML document which is too big for a forum thread to handle. I tried to create a minimal representation of your XML document. If I have missed an important node, please add it back but keep the X...
|
-
Jacob Sebastian Commented 7 Months ago through Ask | 10 Points
When you say 'real-time', what is the maximum latency that you can afford? What are the nature of the source data and what is the target database server? Looking at the minimal problem description available so far, may be what you need is a replication ...
|
-
Jacob Sebastian Commented 8 Months ago through Ask | 10 Points
HIERARCHYID is a data type and it allows you to store hierarchical information. Such as a file/folder structure or an organization chart etc. You may find [this post][1] helpful.
[1]: http://beyondrelational.com/modules/2/blogs/28/posts/17831/sql...
|