Viewing 15 posts - 9,346 through 9,360 (of 49,552 total)
There's a bunch of ways. Do be aware that this often degrades performance, so rather avoid on larger tables or important queries
select * from t_rbt_data
where dt between '2014-01-01' and '2014-03-31'
AND...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 10:21 am
Timeouts are a client-side setting, SQL doesn't give up on queries unless it's told to (kill session or attention call from client app)
There's a lock wait setting somewhere (sp_configure I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 9:52 am
j.b.shteyn (4/9/2014)
So I gave them a quick spiel about creating clustered indexes on the column they join on most frequently and non-clustered on columns in where clause
While that's what a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 9:43 am
It's just how many of the DMVs are implemented, using a mechanism kinda like a linked server. Don't worry about it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 4:09 am
Great. Now drop the table, convert that to a char(10) (nchar if you need arabic, chinese, etc) and then run modified create table, as you have it above.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 4:02 am
First fix your data types.
Second, how do those tables relate to one another?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:50 am
Remove the TEXTIMAGE_ON clause of the create table, as it only has meaning when there is a LOB column in the table
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:50 am
Personally, having written more cert exams than is probably wise (and a lot of them as betas, so complete with poor spelling, grammar errors, confusing questions and nonsensical answers), I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:48 am
Table definitions and easily usable sample data please (as insert statements)
Using SQL 2008 or 2012?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:25 am
Because you defined it as NVARCHAR(MAX), a character string up to 2 billion characters long. Index keys can be no larger than 900 bytes.
Is your product code really over...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:21 am
No, not possible.
A SELECT returns data, the outer-most query is a select, so it is supposed to be returning data, not changing it. What are you trying to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:15 am
Temp tables are created in TempDB. your sequence is in your user database, not TempDB, so the 2-part reference fails as the sequence can't be found.
Edit: Code removed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 3:14 am
Depends on what indexes are available.
The memory request is not the buffer pool space. It's workspace memory for things like sorts, hashes or other query operator operations which need memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 2:41 am
If you want backups that you can restore, DB backups would be useful. Depending how they're doing the server image, it may or may not produce usable databases once restored.
Before...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 2:36 am
Jeff Moden (4/9/2014)
Heh... I tend to blame both. Cruddy tools being used by people that just don't know. It's a deadly combination.
Frighteningly true, especially since the people who...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2014 at 2:28 pm
Viewing 15 posts - 9,346 through 9,360 (of 49,552 total)