Viewing 15 posts - 1,921 through 1,935 (of 6,036 total)
Output parameter gives more flexibility, as you do not need to have the counted SELECT as the last statement.
It even allows you to aggregate 2 or more counts:
DECLARE @sSQL NVARCHAR(500),...
January 19, 2015 at 4:24 pm
I guess it's about SharePoint.
There was an issue when it caused a deadlock during final stages of installation.
As they say - it would be funny if it would not be...
October 28, 2014 at 6:10 am
Koen Verbeeck (7/17/2014)
Sergiy (7/16/2014)
Koen Verbeeck (7/16/2014)
So it is 100% possible to decouple the primary key from the indexCan you illustrate how?
Easy peasy. I draw a table diagram in Visio and...
July 18, 2014 at 12:03 am
Steve Lund (7/17/2014)
Interesting also, is that when you create a PK on a table, in SSMS that it lists that PK under Indexes and not under Constraints.
Look under "Keys".
It's another...
July 17, 2014 at 11:55 pm
Phil Factor (7/17/2014)
Please correct me if I'm wrong but I'd always believed a primary key was enforced by a constraint which was implemented by means of both a UNIQUE ...
July 17, 2014 at 11:53 pm
h.tobisch (7/17/2014)
well, it HAS an idex, so what ?
No, it's implemented in form of an index.
So, IT IS an index.
Take the index away -and there is no key.
Here is another...
July 17, 2014 at 7:00 am
PurpleLady (7/16/2014)
.... but creating a primary key does create a corresponding index (if it doesn't already exist).
Wrong.
It creates a corresponding unique index even if you have 10 unique indexes...
July 16, 2014 at 7:27 pm
Koen Verbeeck (7/16/2014)
So it is 100% possible to decouple the primary key from the index
Can you illustrate how?
, as the latter one is just a matter of implementation.
The fact of...
July 16, 2014 at 7:21 pm
Check that the domaun account used for trusted connection is registered against the database and is allowed to select data from the table.
October 23, 2013 at 4:17 pm
Steve Jones - SSC Editor (10/22/2013)
I like Sergiy's advice.
I better like this:
generate the statements on the fly, replace all special chars with e.g. "_" in the part where that script...
October 23, 2013 at 4:03 pm
Benki Chendu (10/3/2013)
The maintenance plan runs for all database backups. Its a generic job.Do you have any more inputs.
Try to use double quotes around the file names:
BACKUP DATABASE [safe_PreTMS ]...
October 22, 2013 at 8:00 pm
When you go to DOS you execute the command in your desktop/laptop environment, and "C:\Temp\OrderNo_123.xml" is a file on your computer with your user having administrative permission over it.
When launch...
October 22, 2013 at 6:54 pm
I believe "indexes with only one column" does not reveal all the indexes we need to see.
Clustered indexes with 1st column of uniqueidentifier type are as bad, probably even worse.
Following...
October 22, 2013 at 6:35 pm
That procedure might have multiple "reiterating" update while a row is added to the table.
Extremely bad but at the same time very popular approach.
Trigger is launched during every one of...
October 15, 2013 at 10:41 pm
Viewing 15 posts - 1,921 through 1,935 (of 6,036 total)