Viewing 15 posts - 211 through 225 (of 3,011 total)
64 GB is the limit for SQL Server 2012 Standard Edition
Memory Supported by the Editions of SQL Server
http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx
June 4, 2013 at 1:36 pm
Jim P. (6/3/2013)
phonetictalk (6/3/2013)
June 4, 2013 at 12:55 pm
Luis Cazares (5/30/2013)
GilaMonster (5/28/2013)
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the snapshot isolation levels. Financial or...
May 30, 2013 at 10:07 am
Just curious. Why is there a need for this?
May 29, 2013 at 12:55 pm
This script will give you detailed information about the database files analyzed multiple ways:
Get Server Database File Information
May 23, 2013 at 11:28 am
isuckatsql (5/21/2013)
Thanks for all the feedback!Michael,
I just changed from dynamic sql to structured sql, due to concerns about sql injection !
If you do dynamic SQL correctly, there is no danger...
May 21, 2013 at 1:16 pm
You should convert your stored procedure to use dynamic SQL.
The article below will explain the many good reasons for doing this.
SQL in the Wild: Catch-all queries
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
May 21, 2013 at 12:23 pm
select
a.*,
TruncateMillseconds =
dateadd(ms,-datepart(ms,a.DT),a.DT)
from
( -- Test data
select DT = getdate()union all
select DT = '2012-06-20 23:00:56.397'
) a
Results:
DT ...
May 20, 2013 at 9:03 pm
JaxieLaidey (5/17/2013)
Thanks for your reply 🙂 However, how can I get the display to look like this '8/1/2009 00:00:00.000'? Right now it displays '2009-10-01 00:00:00.000'
SQL Server DATE or DATETIME columns...
May 17, 2013 at 8:14 am
I suggest changing the security model of the application so that end users do not have direct access to the database.
May 17, 2013 at 7:45 am
If your Years and Months are valid (always a big if):
select
a.[Year],
a.[Month],
[Date]= dateadd(month,(12*a.[Year])-22801+a.[Month],0)
from
( --Test Data
select [Year] = '2008', [Month] = '2'union all
select [Year] = '2000', [Month] = '12'union all
select [Year] =...
May 17, 2013 at 7:30 am
The snapshot file (.ss) just contains before images of changed database pages. Since the page is encrypted in the source database, it is encrypted in the snapshot. The...
May 14, 2013 at 8:57 am
The snapshot will be encrypted if the source DB is encrypted.
May 14, 2013 at 8:40 am
This site is for Microsoft SQL Server questions, and does not deal with Netezza.
May 9, 2013 at 8:56 am
Viewing 15 posts - 211 through 225 (of 3,011 total)