Viewing 15 posts - 1,231 through 1,245 (of 2,649 total)
changing part of Scott's code should work.
SELECT @sql = STUFF((
SELECT ', ' + 'MOVE ''' + LogicalName + ''' TO '''
...
February 16, 2021 at 12:25 am
DDM is NOT a good choice for anything - for ad-hoc users its not like they can unmask it but they can infer the data and after multiple attempts they...
February 15, 2021 at 6:26 pm
as a important note get ride of those with(nolock). if your business is ok with possibility of having bad data supplied to them you can add a single statement at...
February 13, 2021 at 6:53 pm
Social Security numbers are considered PII and are a attribute of an individual/company and should be stored securely and are for this reason a bad choice for PK - other...
February 12, 2021 at 7:45 pm
the following code will work - .mdf file CAN NOT be opened by SQL Server when it is done as SQL will exclusively lock the file.
as everyone said this is...
February 12, 2021 at 5:25 pm
Thanks @frederico, but wouldn't the data pages keep on changing every time we run index reorg or index rebuild?
yes - but by giving them those pages on a file...
February 11, 2021 at 10:25 pm
you can - but it would be completely useless for any intents and purposes. small c# program open file binary, read first 25 pages (25*8k bytes) and do same for...
February 11, 2021 at 7:00 pm
not wishing to minimize the article itself which I consider well written I wonder why would posting this on a SQL Server forum be a good idea.
February 9, 2021 at 2:53 pm
No issues from a compatibility point of view for having both running on same box - obviously resource sharing is where one may impact the other but if both are...
February 2, 2021 at 6:49 pm
not sure if it was just a typo but the example supplied is only adding a single quote to the item on the middle - so clarification on the requirements...
February 1, 2021 at 10:57 pm
lots of things can cause that - but without table definitions (including indexes and FK's), row counts for each table, view definition as well as any function used within those...
January 31, 2021 at 9:03 pm
LastName INCLUDE (ProductID, FirstName) and LastName INCLUDE (FirstName) are the same in this case as ProductID is the clustered index "key".
regarding your indexes I misread your original post.
LastName, DateDeleted INCLUDE(FirstName)WHERE...
January 29, 2021 at 12:06 pm
was apply available on sql 2005?
January 29, 2021 at 11:41 am
your issue is not the ProductID but the DateDeleted. This last field is what is causing the key lookups as it is not part of the second index (ProductID is...
January 29, 2021 at 11:37 am
might be worth checking filenames of attachments - could also happen that someone adds a filename with special characters just in case it does not go through same code
January 28, 2021 at 11:43 am
Viewing 15 posts - 1,231 through 1,245 (of 2,649 total)