Tagged Questions
Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).
0
votes
2answers
53 views
Production (20GB+) Database running slowly and timing out
I know the title thread is a bit ambiguous (and my first post here!) but I am having a very severe production database problem. I am not a DBA, though I know how to work with queries and SQL Manager. ...
0
votes
1answer
19 views
Warn about table recreation on table change
By default, if you try to change a table using the designer making any of the following changes, you get an error message:
You change the Allow Nulls setting for a column.
You reorder columns in the ...
0
votes
3answers
30 views
how to grant select access my sql server
when I exec the syntax to gain the access I get an error that I cant grant permissions to my self.
any Ideas please!
0
votes
0answers
28 views
how to manage coexistence of SQL Servers 2005/2012 within Windows Server 2012 [on hold]
Currently, a W2k8 server is used with a SQL Server 2005 Dev. Edition. That works of course. Only a strange problem occured after the installation (which includes mixed mode auth.). Windows ...
0
votes
1answer
17 views
How to create login and logout trigger for client audit?
I need a table to put login and logout information for client not sysadmin,then i can use date to statistic user login/off ration...
Can anyone offer me a simple method to create login and logout ...
0
votes
2answers
18 views
Xml stored as varbinary
I'm wondering if I have to
store a XML information inside a column (just storing, not for querying ) (SQL SERVER)
which Datatype is better to use XML or Varbinary? I did an example:
DECLARE ...
0
votes
1answer
33 views
Convert SQL Server query to MS Access syntax
I have this query in SQL Server:
SELECT Dated, AccountID, AccountName, Rate,
case (when (Credit-Debit) > 0 then Credit-Debit END) as Credit,
case (when (Credit-Debit) < 0 then Credit-Debit ...
0
votes
1answer
27 views
How to insert and or update a variable number of records and prevent concurrency issues
I currently have the following stored procedure. However I am seeing some race conditions where I end up with incorrect data which I think is caused because the procedure isn't attomic and it can be ...
1
vote
1answer
29 views
What's the official successor for sp_resetstatus in case of a SUSPECT database?
I have a database that has been marked SUSPECT because the volume that both the data and the log file were on suddenly disappeared (an accident - this is a developer workstation). I tried bringing the ...
1
vote
0answers
45 views
storing arrays or images in a database table
I'm a beginner with both database design and use of forums such as this one so forgive me if I forget to provide some relevant information below.
Basically I'm trying to store a set of arrays, in ...
1
vote
2answers
48 views
SQL Server 2005 get execution plan of a overnight stored procedure
There is a overnight job runs long time. I have used profiler to get the trace and identified a statement (in a stored procedure) that takes most of execution time. Now I need to see the execution ...
0
votes
2answers
31 views
Updating an indexed column performance impact in SQL server
I am trying to understand is there any performance impact if I am trying to update a column which is the key column of a non-clustered index in SQL server 2008? For e,g
I have a column IsActive in ...
0
votes
0answers
45 views
Use of Case Statement result in Join [on hold]
Let's say I have a Case statement, something like this:
SELECT
CASE
WHEN SC.Original_Order_Id IS NOT NULL
THEN SC.Original_Order_Id
WHEN P.Product_Name like '%Bundled%'
THEN ...
4
votes
1answer
28 views
Failover scenario with principal “hard down”
My company has a failover pair of SQL Server 2005 instances, which provide database availability for a UL-licensed alarm/call center, where uptime and availability are critical for life safety.
...
1
vote
0answers
36 views
MS SQL Server: Can Unicode columns include non-unicode values?
I need to convert UNICODE column values from UTF16-LE to UTF-8 to then import into MySQL. Is it safe to assume columns of NVARCHAR, NTEXT, NCHAR, BIT, INT, DECIMAL, FLOAT, and DATETIME all MUST be ...
