Viewing 15 posts - 6,106 through 6,120 (of 13,874 total)
mikevessey (1/6/2017)
The key point is PHYSICAL .
A clustered index does not determine the order it is stored on disk.
I went to a...
January 6, 2017 at 8:48 am
Phil Parkin (1/6/2017)
Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.
Assuming version 16 is there, try running...
January 6, 2017 at 8:20 am
On your SQL Server instance, in SSMS, go to
Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.
Assuming version 16 is there, try running the export...
January 6, 2017 at 8:19 am
RonKyle (1/6/2017)
SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is if...
January 6, 2017 at 8:03 am
mikevessey (1/6/2017)
a clustered index does not prevent duplicates
a primary key (normally also the clustered index) or also a unique constraint will prevent duplicates
the clustered index...
January 6, 2017 at 5:16 am
John Magnabosco (1/5/2017)
January 5, 2017 at 6:14 pm
TheSQLGuru (1/5/2017)
Phil, why would you put a clustered index on the temp table?
1) Helps validation by ensuring there are no duplicates (of course, you may not always want this)
2) Maybe...
January 5, 2017 at 1:33 pm
Luis Cazares (1/5/2017)
Basically, your stored procedures would have a format similar to this:
CREATE PROCEDURE SomeReport (
...
January 5, 2017 at 11:42 am
Fuseball sounds like it could go off with a bang.
January 5, 2017 at 11:31 am
Luis Cazares (1/5/2017)
Phil Parkin (1/5/2017)
Does anyone have any idea why a thread I created yesterdayhttp://www.sqlservercentral.com/Forums/FindPost1847804.aspx
appears to have removed or marked as spam?
Maybe you were selling kitchens? Or fake documents? :hehe:
Of...
January 5, 2017 at 8:07 am
Does anyone have any idea why a thread I created yesterday
http://www.sqlservercentral.com/Forums/FindPost1847804.aspx
appears to have removed or marked as spam?
January 5, 2017 at 7:03 am
Have you tried using Reporting Services (SSRS)? The tools that you mention are not really presentation tools, which is what you need here. A Tablix in SSRS should get you...
January 4, 2017 at 1:51 pm
Homersdonut (1/4/2017)
The file name looks like it is of the standard flavor "sql...
January 4, 2017 at 12:37 pm
mandavli (1/4/2017)
is there any pre-existing alert that I can use or do I need to create a script? if so then which tables shall tell me of what's new?
Why did...
January 4, 2017 at 8:23 am
drew.allen (1/3/2017)
Both THROW and RAISERROR cause side effects and user-defined functions cannot cause side effects, so you cannot use a THROW or RAISERROR in a UDF.Drew
Shows how often I write...
January 3, 2017 at 6:14 pm
Viewing 15 posts - 6,106 through 6,120 (of 13,874 total)