I have a query that has appropriate indexes and is shown in the query plan with an estimated subtree cost of circa 1.5.The plan shows an Index Seek, followed by Key Lookup - which is fine for a query
We have an analytics database server running SQL 2008 R2 with 192 GB of physical RAM. However, we\'re noticing that during analytics process, the server only uses around 70 GB, bu开发者_C百科t tempdb
I need to call some Stored Procedures from Delphi and because they are related I have to use transactions.
If I have a simple table and I want to do something (say .. execute a stored procedure) when a column (and I know the column I wish to look for) has changed.
I have Ticker, Dt, [Open], Volume for the input table Dt is yyyy-mm-dd I want to return every row where ticker = \'IBM\' and also returns the Ticker, Dt, [Open], Volume fields and then include a ma
Is it possible to obfuscate or scramble a column in SQLServer 2008 R2 without hav开发者_StackOverflow中文版ing to use encryption or some highly ineffecient custom made function that does substrings?Wh
I need to search in a table for items which have all of my desired values in a column i.e. I have table :
I am setting up my development machine and I am wondering if I should install SQL Server 2008 R2 (for Developers) or SQL Server 2008 (for Developers) on my machine.
My problem is that I am receiving a \"Configuration system failed to initialize.\" error every time I try to open or create a Business Intelligence Project in Business In开发者_开发技巧telligence Deve
We are using a SQL Server Data-tier application (dacpac or DAC pack) and I\'m having a hard time finding the current version of the database.
加载中,请稍侯......