Stephen West
Forum Replies Created
-
Posts
-
Run this:
SELECT d.plan_handle , d.sql_handle , e.text FROM sys.dm_exec_query_stats d CROSS APPLY sys.dm_exec_sql_text(d.plan_handle) AS eAnd filter output with
WHERE text like '%something%'No this query is only to rebuild a defragmented index. But you can rebuild all indexes in a table by using the following query
USE AdventureWorks2012; GO ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON); GOExecute the below query
USE AdventureWorks2012; GO ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee REBUILD; GOYes, you can do it by using SQL Server Management Studio or using T-SQL.
have you checked the permissions to do it?
Try to restore a backup to another server and do some disk checks on your primary machine.
run the following query to find the last update
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'AdventureWorks') AND OBJECT_ID=OBJECT_ID('test')use the following query:
BACKUP DATABASE [AdventureWorks2012] TO DISK = N'F:\Backup\AW12.bak' WITH CHECKSUM;You can use
Web SQL APIwhich is an ordinary SQLite database in your browser and you can open/modify it like any other SQLite databasesTry the following steps:
1. Open SQL Server Management Studio and connect to your database server.
2. Right Click on Database Server and click Properties.
3. Set the Server Authentication to SQL Server and Windows Authentication Mode.not sure, I know when stored proc was called, from my webserver log, now trying to track it down on db logs.
For a binary blob? That would be in violation of the SQLite documentation which says blobs are treated as text and as such length() is accurate only until it finds a \0 character
You should avoid directly manipulating the database and use migrations instead. If you forgot to add a column then you should create a new migration using add_column to add the column to the table.
Alternativly if the previous migration was the one that created the table with the missing column and you’ve not distributed this migration yet you can do rake db:rollback, editing the migration and run rake db:migrate again.
Your lack of tables when running the sqlite command is most likely because you forgot to specify the sqlite file to load: sqlite3 <db_name>
You can use the date created property from the file system to choose the youngest backup. This was the solution I wanted.
When the SQLCommand.CommandTimeout is set to zero, you expect an infinite timeout. However, versions 1.1 and 1.0 of the SqlClient provider incorrectly timeout when a response from SQL Server is broken into two packets. Immediately upon receipt of the second packet, versions 1.1 and 1.0 of the provider incorrectly timeout. The fix that is included in this article fixes this issue so that the command will have an infinite timeout.
Did you create the table originally via a migration?
Can you make the below verification to see whether your encryption and decryption works correctly or not..
In Old Server
OPEN SYMMETRIC KEY [key_name] DECRYPTION BY CERTIFICATE key_cert; GO SELECT encryptbykey(key_guid('key_name'), 'TestData') GOIn New Server
OPEN SYMMETRIC KEY [key_name] DECRYPTION BY CERTIFICATE key_cert; GO DECLARE @blob varbinary(8000); SET @blob = 'output from earlier select statement' SELECT CONVERT(varchar(8000), decryptbykey(@blob)); GOClose symmetric keys in both servers
CLOSE SYMMETRIC KEY [key_name]; GO