Viewing 12 posts - 16 through 28 (of 28 total)
Carolyn S. White (1/20/2014)
I need to change this how?
I get the error
Incorrect syntax near 'o'.
I tried changing SCHEMA_NAME to the name of the schema for the...
January 20, 2014 at 8:11 pm
danaanderson (1/18/2014)
January 18, 2014 at 6:55 pm
mikeg13 (1/17/2014)
January 17, 2014 at 7:25 pm
I would use AND INDEX_ID <= 1 when index space is not needed.
Index ID 0 is for heap tables and Index ID 1 is for tables with clustered index.
January 17, 2014 at 7:12 am
Can anyone please confirm this new update? Is it true we have 90 days now?
http://www.theregister.co.uk/2013/09/10/microsoft_says_axed_certs_failed_its_software_biz/
September 10, 2013 at 7:12 am
Jeff Moden (9/3/2012)
Be careful now... That uses a "counting Recursive CTE" and they're notorious for bad performance. Please see the following article for why you shouldn't use "counting...
September 3, 2012 at 11:02 pm
Looks like an interesting design. Here is how I would do it:
--Create sample table
create table MonthlyData
(
YearMonth nchar(6),
Value decimal(7)
)
insert into MonthlyData
Values
('201207',5000),
('201208',4000)
go
--Query data
;With DaysInMonth as
(
select
YearMonth,
Value,
DATEFROMPARTS(cast(SUBSTRING(yearmonth,1,4) as int),cast(SUBSTRING(yearmonth,5,2) as int),1)...
September 3, 2012 at 10:32 pm
Agreed with GilaMonster, blindly shrinking a database might not be the best way of reclaiming space.
For this particular issue. If you are in a rush to get the server...
August 17, 2012 at 12:26 pm
You could try something like this:
--Create Server Audit:
USE master;
GO
CREATE SERVER AUDIT Login_Audit
TO FILE (FILEPATH = 'd:\sql_temp\Login_Audit',
MAXSIZE = 2GB,
MAX_ROLLOVER_FILES = 10)
WITH (QUEUE_DELAY = 0, ON_FAILURE = SHUTDOWN);
CREATE SERVER AUDIT SPECIFICATION Login_Logout_Audit
FOR...
August 9, 2012 at 10:33 pm
A second though on second scanario: max BID of table, this query looks clean (still need aux_numbers table):
with FullBID as
(
select ID,
number
from (select distinct ID from QA_Test) q cross join aux_numbers
where...
August 9, 2012 at 2:58 pm
nikki_d (8/9/2012)
I need the result like this..all missing number between '001' to max(bid)IDBID
1232
1253
1256
1283
If we have '010', '030', Missing items will be '011','012'....'029' .
Looks like this BID is treated as...
August 9, 2012 at 2:29 pm
The data type char(6) is difficult to tell what is missing in this case.
What is the logic that determines '003' is missing from 123?
Let's say we have...
August 9, 2012 at 9:13 am
Viewing 12 posts - 16 through 28 (of 28 total)