python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - ssms

Why is my SSMS default .mdf file folder is empty?

Why is my default SSMS database .mdf file folder 'empty'? I have searched for an answers for hours now and cannot find anything. In SSMS, the properties of the database I am after says the file is at ...
test-img

Brydon

sql-server

database

ssms

mdf

Votes: 0

Answers: 1

Latest Answer

The folder isn't empty, you just don't have permissions to view the folder, and so when you get the properties of the folder you get information on what you can see: nothing. If you try to actually op...
test-img

Thom A

What is breaking this Case When Statement? (Pardon if this has been asked)

obligatory "New to T-SQL" inserted here. I'm running into an issue where an ' is in the value returned in the data and receive the error "syntax error near 'S'". below is an exampl...
test-img

EDG_507

tsql

ssms

Votes: 0

Answers: 0

Trimming inconsistent values in a column

I have such an issue. On column namely t.DC has sometimes other values after the number for example 01 ROYAL 40 ABC Trying to see if there is anything that can erase those names after digits leaving...
test-img

Papapariski

sql

ssms

Votes: 0

Answers: 1

Latest Answer

Well you could try something like this: SELECT t.Chain, CASE WHEN t.DC LIKE "DC%" THEN SUBSTRING(t.DC, 3, 2) WHEN t.DC LIKE "[0-9][0-9]%" THEN LEFT(t.DC, 2) ...
test-img

Pat Jones

Difference between 'process default' and 'process full'?

What is the difference between ‘Process Default’ and ‘Process Full’? When I do ‘Process Default’ it works fine, but if I use ‘process full’ I get this error? Why is this??
test-img

Chicago1988

ssms

ssas-tabular

Votes: 0

Answers: 2

Latest Answer

See doc at https://learn.microsoft.com/en-us/analysis-services/tabular-models/process-database-table-or-partition-analysis-services?view=asallproducts-allversions#bkmk_process_db Default won't load da...
test-img

TheRizza

Posts

Questions

Blogs

Jobs