Forum Replies Created
Viewing 15 posts - 3,001 through 3,015 (of 49,552 total)
-
RE: Something about licensing SQL Server
https://www.microsoft.com/en/server-cloud/products/sql-server/purchasing.aspx and click the "Read the SQL Server 2016 Licensing datasheet" link. (or http://download.microsoft.com/download/F/D/5/FD5E5C28-6973-4273-8737-D69AA3BEA243/SQL_Server_2016_Licensing_Datasheet_EN_US.pdf, though no guarantees it won't move.)
The 2012 and 2014 licensing guides had similar wording, though they're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: MSSQL 2016 express edition
First result on google.
https://www.microsoft.com/en/server-cloud/products/sql-server-editions/sql-server-express.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Performance / Query Tuning Question Regarding Missing Indices
alex.sqldba (6/1/2016)
But the overview is we have a table and process (the process cannot change) that has hints that put a holdlock and update lock on a table.Be careful...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Sean Lange (6/1/2016)
Brandie Tarvin (6/1/2016)
I am having the worst time today reaching the forums via Internet Explorer. It just hangs and hangs.Anyway, has anyone heard about the latest data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Can we just lock the schema rather a DB?
Err, SQL doesn't have a built in way to 'lock' a database, so it must be something that you've built. Can you explain how you 'lock' databases?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Something about licensing SQL Server
paolobianchi (5/31/2016)
But the question is: if i buy license for 4 core and install SQL Server on this server with 8 core, simply SQL Server does not use every core...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Must declare the scalar variable "@value4".
You're declaring the variable outside of the dynamic SQL, hence it's out of scope inside the dynamic SQL.
Since it's intended to be an output parameter, you'll need to use sp_executeSQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Brandie Tarvin (5/31/2016)
jasona.work (5/31/2016)
Brandie Tarvin (5/31/2016)
GOOD MORNING, THREADZIANS!Because I just felt like randomly shouting something this morning. @=)
And a good morning to you as well!
I feel I have made a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Questions
Lowell (5/31/2016)
that is a great set of study topics for anyone starting out in SQL.Well, it was.
Though the first one wasn't really a study area:
Do you have experience in MS...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Questions
Interesting set of interview questions.
What were your answers?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL authenticated logins and passwords
No.
The passwords aren't encrypted. They're hashed and cryptographic hashes are one-way processes. You cannot extract the plain-text password from the hash.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Unusually large Differential Backups
The way diff backups work:
Any change made to a page results in a bit being set to 1 in the differential change map for the extent that contains the page....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Unusually large Differential Backups
A copy-only backup won't affect the size of differentials.
What else happened around the same time? Index rebuilds?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Brandie Tarvin (5/27/2016)
So, since we have such an international cohort here, what holidays are coming up this weekend / Monday in YOUR country? Because I'm curious what their official names...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: do not set any locking\blocking
Have you tried read committed snapshot? Won't help with deletes blocking inserts, but will help with reads.
And have you checked the indexing to make sure it supports the queries? Poor...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 3,001 through 3,015 (of 49,552 total)