Laden...
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Getting the Date | |
In the R language, how do I get the current date of the system? | |
Think you know the answer? Click here, and find out if you are right. |
|
Yesterday's Question of the Day (by Junior Galvão - MVP) |
Database Properties In previous versions of SQL Server, the Page_Verify database property algorithms were used to verify and identify possible incomplete, suspected, or broken pages of data. In SQL Server 2017, what is the new option that should be set to add a certain bit in the header of a page? Answer: CheckSum Explanation: The correct answer is the option: CheckSum. The Checksum option, creates a checksum value using the content of the entire page, and saves that value in the header. When a page is read from disk, a checksum is created again and compared to the saved checksum. Since any difference in the bytes read for that page will result in a different checksum value, this is a far more thorough method for validating IO. References: http://www.sqlservercentral.com/blogs/cleveland-dba/2012/06/07/page_verify-checksum-vs-torn-page-detection/ https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-2017 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Upgrading from SQL2008 sp2 - Hi, Anyone upgraded their SQL to version 2017 from SQL 2008 SP2 using backup restore? Is it mandatory to upgrade to SQL2008 SP4 then do backup restore on SQL2017? Thanks |
Double click .sql file opens new SSMS session - When I double click a .sql file, it opens SSMS. If I double click a second .sql file, it opens a new SSMS session instead of a new tab on the current SSMS session. We are running v17.8.1 Is there setting for this. Have already looked at the following posts and none of this worked: […] |
SQL Server 2016 - Development and T-SQL |
Performance difference for stored proc in SSIS vs SSMS (and other questions) - I have a humongous data set that I am updating from another humongous data set. We are talking about hundreds of millions of rows being updated. Apart from partitioning these tables (which are processed by single year batches) I have tuned the update query and indexed the tables so that the execution plan looks very […] |
Administration - SQL Server 2014 |
server slowness - Hello there are 2 servers A and B with the same settings. However when I try to run a select count(*) in server A it takes 6 seconds whereas in the other it takes 18-28 seconds can anyone let me know how or where to check for the problem |
Development - SQL Server 2014 |
Merge all rows to one row in results - This is working, thank you to Drew Allen from this forum. I would like to know if this can be tweaked a little. select ai.*, pe.program_name, ac.full_name from all_clients_view ac left outer join alt_id_view ai on ac.people_id = ai.people_id left outer join program_enrollment_view pe ac.people_id = pe.people_id Currently, the result will be like this for […] |
Using a third table in small left outer join - HI I have 2 views and I need one more information and not sure how to do this. I thank you for all of your help so far. select b.*, a.full_name from all_clients_view a left outer join alt_id_view b on a.people_id = b.people_id I need to add in the program_name from this view: I don't […] |
SQL 2012 - General |
How to find a set of sequential values within a list - Hello all, I have a dataset with lat/lon data for vehicles tracking their location every few minutes. It also reflects an estimated speed of travel and the time the record was received/recorded in the database. A small sample of the data for one vehicle: CREATE TABLE #TESTDATA ( VEHICLEID INT ,LAT INT ,LON INT ,MSGDATE […] |
SQL Server 2012 - T-SQL |
t-sql 2012 most current year - In the following t-sql 2012, I want to select records from the AMilestone table when the schoolyear is the most current year from the ASemester table. select * from ASemester ASemester join AMilestone AMilestone on AMilestone.SCHOOLYEAR = ASemester.SCHOOLYEAR where ASemester.SCHOOLYEAR = ASemester.max(SCHOOLYEAR) The sql listed above does not work. Thus would you show me the […] |
T-SQL (SS2K8) |
how to encapsulate the same code block with inserted vs deleted in a trigger. - So I have an IUD trigger on a table with quite a few columns. (Don't ask about normalisation that's another issue). My code is … INSERT INTO auditTable (a,b,c … k) SELECT a,b,c...k FROM inserted Later I repeat the exact same for the table deleted. I was trying to think of a […] |
Analysis Services |
Calculations - Associated Measure Groups - Hi, I have a current calculation in my cube called 'EUR Rental Value', I added a new calculation called 'USD Rental Value' and when I use excel to connect to my perspective I notice that the new calculation is displayed under the 'Values' measure group and not the 'Sales' measure group. The weird thing is […] |
Integration Services |
SSIS Script task varaible - Hi Team, I have a script task variable called User::EntryData of type String and I have a string value (Dictionary ) in C# to the Entry date SSIS variable and I am trying to pass it to a Foreach loop enumerator using foreachvariable enumerator and loop through all the elements in the variable. But it […] |
SSIS Script task varaible - Hi Team, I have a script task variable called User::EntryData of type String and I have a string value (Dictionary ) in C# to the Entry date SSIS variable and I am trying to pass it to a Foreach loop enumerator using foreachvariable enumerator and loop through all the elements in the variable. But it […] |
SSIS bcp command unable to open bcp host data file - I have a developer that created and SSIS package that uses bcp. the bcp command is on a process task the working directory is the tools\binn for sql server (2012). the executable is bcp and the arguments are out "business" -c -t~ -T -SXXXX There are expressions used in the command @[User::TableName] + " out […] |
SQLServerCentral.com Announcements |
Status Update 8 May 2019 - Apologies for missing yesterday. A little coordination problem with a PM out and new people working. I didn't see changes and needed to dig into a few things. We are starting to see some fixes appearing in small ways, and some larger backend ways. Fixes: Redirections should be mostly working. We also have Google/Bing/etc reindexing […] |
SQLServerCentral.com Test Forum |
Another test to ignore - Just trying to test some things..... |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...