CREATE TABLE [dbo].[Client]
(
[SSNum] NCHAR(20) NOT NULL,
[CCNumberPrimary] NCHAR(20) NOT NULL,
[CCNumberSecondary] NCHAR(20) NOT NULL,
[CCNumberTertiary] BIGINT NOT NULL
)
CREATE CLUSTERED INDEX Client_Index ON Client (SSNum)
INSERT INTO [dbo].[Client] ([SSNum], [CCNumberPrim...
> By late afternoon, Denver police had issued 47 citations for public marijuana consumption at the downtown rally, as well as 16 other arrests or citations for other reasons. Denver Health Medical Center paramedics had treated 14 people, including three who were taken to detox. The hospital's emergency room had treated about a half-dozen people, most of whom had passed out through a combination of sun and substance use.
> Brittany Gibbs caught one of the police citations Sunday when she lit up her chillum pipe on the outskirts of the rally just before police officers on bicycles rode by. They handed her a $150 ticket for public marijuana consumption.
"They said, 'Go into a crowd where we can't pick you out,' " Gibbs said.
@Kermit here are pictures ... because you dont read the articles
I type description about my game in All Application tab, in tab Game Services it required Display name and Description, I only need create LeaderBoard with Game Services, what should I type in Display name and Description?
@MikeFal i like that he's passionate about it, but i think he's got much more to share with the community than oc. oh well - it was what it was. and it wasnt bad
@MikeFal hey. don't talk smack. i remember a certain goalie's last series ever in his career against a team who was down 3-0 and came back to win the series
@MikeFal meh. it was what it was. it was fun and interesting but i didnt have any major takeaways
Your boys will need to find a new place to put the puck because that 6 foot + beast will not be giving up that glove side shot Brysgolov(probably misspelled) gave up so readily.
I got office program. This program stores his data in SQL Server 2008 Express, but there is no management studio and no sqlcmd. How can i get into pure SQL tables, to use them in my plugin.
@ShawnMelton Not enough information. I'm trying to understand what he's trying to do. And also, I want to beat the person who mentioned osql as an alternative.
IDE: Microsoft SQL Server Management Studio
Mistakenly I have cleaned a table data using
delete from table tblBookData
and now it has cleaned that table, please tell me is there any way to get back that data?
If yes than please tell me the process, as I have studied there is a way to get ba...
@Zane if not, then you can be more passive-agressive. Like laughing every time they say something stupid and sigh and say "people are stupid" or something like that
(don't confuse my previous comment with an actual advice)
Hi everyone! What's the syntax for enabling multiple trace flags in SQL Server? I've tried -TXXXX YYYY ZZZZ and -TXXXX,YYYY,ZZZZ but no dice - only the first flag gets enabled...
It works when I specify it like ;-T1111;-T2222;-T3333 but that seems pretty klugy; it would be nice to just specify the -T once.
wanna know what's awesome? trying to change the recovery model of a database to add to an availability group and taking a fully backup with COPY_ONLY (hidden from screen). log backup fails. derp
Any server, really. What users have permissions to run DBCC commands on a server where you need to double-check the output of those commands after the fact?
Do the point where you need every single DBCC command to be logged? If you have maintenance plans where specific DBCC commands need to be logged, you can manually put a session-level TF on.
Won't DBCC raise an error with a severity that you can trap / alert? Who is really going to be poring through gigs and gigs of error log data looking for corruption?
I guess I'm lucky enough that I've never had corruption issues to deal with, so I'm not really sure about it. I have alerts setup for various error severitys of 16 to 25 so I assume I will get notified.
@AaronBertrand thanks for that!
@swasheck I'm going to now.
@AaronBertrand cleaning up the error log on these servers is already going to be a herculean task. I appreciate the advice.
I would highly recommend using the TF that suppresses "backup succeeded" information from going to the error log. On a server with 2000 databases, that is going to be a disaster (unless you're a cowboy with no backups).
Sorry I forget the TF off the top of my head and monitoring lunch on the stove
Have an issue regarding the queries with GROUP BY. This is the following statement that I use so I can create the query:
SQL> SELECT invoice_num, technician_num, service_advisor, invoice_date_in, customer_id
2 FROM invoices_TP
3 GROUP BY invoice_date_in;
And this is error I get every time I t...
@JNK I'm trying to mine the plan cache for what seek predicates are used against a specific table. I can find the nodes with the attributes, but I want to pull them out in a concatenated list (1 row) so I can compare which sequence of predicates are used.
YEah, gimme a bit, I'm kind of in the middle of futzing. Of course, the other side of this is making sure I know that I'm getting what I should be getting.
As far as licensing is concerned with Oracle, there are some amazing tools and internal views (AWR etc) that make it really easy to diagnose perf problems, but you have to buy a license. The older statspack scripts still work, but they're inferior and use less granular data
Partitioning is expensive as an option too, but people tend to overuse it anyway. It's primarily best used as an archival tool. You can emulate it with a view over many tables trivially
Well, SQL Server locking and serialisation baffles me. Load of shit. Every Oracle app I've ever worked with has used the default [sane] isolation level. No NOLOCK crap :P
Eh, Microsoft has had plenty of time to "fix" it. And they sort of did with Snapshot Isolation, but a lot of it is just the foundation they chose to build upon.
they pulled the power to something during an NFS write do the drive and the mount point is broken, can't unmount so I can't put anything at /mnt/abc123
@Martijn SE have a long track record of caring what the community wants. Not necessarily doing what the community wants, but definitely caring. The goal of this post is find out the strength of feeling among us, in the hope that SE will be prompted to start making plans for the future of our Markdown. — Jack Douglas2 days ago
DECLARE @TableName sysname = 'Journal'; SET @TableName = QUOTENAME(@TableName,'[');
WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan') ,IndexSearch AS ( SELECT qp.query_plan ,cp.usecounts ,ix.query('.') AS StmtSimple FROM sys.dm_exec_cached_plans cp OUTER APPLY sys.dm_exec_query_plan(cp.plan_handle) qp CROSS APPLY qp.query_plan.nodes('//StmtSimple') AS p(ix) WHERE query_plan.exist('//Object[@Table = sql:variable("@TableName")]') = 1 ) SELECT TOP 10 StmtSimple.value('StmtSimple[1]/@StatementText', 'VARCHAR(4000)') AS sql_text
I was quite happy with CSV etc when I started my career. Then all files became 20 times bigger!
Was a massive problem though. Previous clients had a section break, then comma seperated. So "10" would be "10". Then it became <CallDuration>10</CallDuration> and <SMSDateDelivered>2010090510203030</SMSDateDelivered>
Clients went bananas about the storage space increase, as did i
Not to mention speed of processing. Somebody changed a process here several years ago that went from directly inserting some data into the db in a 'queue table' through a connection, to writing it out to a series of XML files which gets put in a queue and then the queue reads the files and writes to the DB...1000x slower, at least
Was on a project for a very big telco and the clueless IT security bloke was trying to enforce strong encryption between the app and DB server. Their firewall rules were so strong that I had to go into the data center and install the app via a serial cable. The 2 servers were in a rack next to each other. The performance hit for encryption doubled the hardware needed
@FreshPhilOfSO ya, this whole mess I'm in now started because our sysadmin setup two Exagrid nodes to replication...across a 10Mb/s network. And the initial replication was about 1.8 TB
and the two Exagrid boxes are like....6 ft from each other. And he could have set them up on the gigabit network
I'll openly admit I worked for bskyb on a contract and sat next to their head of IT security. I used a SSH tunnel for all my browsing, sent external DBS via that, and he always joked he'd catch me if I did anything wrong. "Just been on another security course blah". If you need to go on one then..... Well
@JNK i dont want to eyeball it. i want to find the plans in cache that are doing lookups and see if i can get the columns that are least "covered" by our current indexing
so i've got the lookup retrieval down pat
and i have my output columns and my seek columns
but i dont want to irresponsibly aggregate them
and misclaim that a column needs to be included in some sort of indexing strategy revamp
@swasheck There a three basic reasons a lookup can exist. (1) to retrieve additional columns; (2) to apply a predicate to an uncovered column; (3) both operations on the same column.
The "seek" columns are typically not that useful because the lookup seek is just locating the row in the base table using the clustered key or RID.
That query has a predicate on a column the Name index does not cover. So, we get a Key Lookup to fetch Color and apply a predicate, but the column is not returned from the lookup (and so does not appear in the OutputList).
@PaulWhite ok. so now we're back at where i thought i was :). i guess i dont understand this in that context, 'The "seek" columns are typically not that useful because the lookup seek is just locating the row in the base table using the clustered key or RID.'
@swasheck Point is, that Key Lookup has an empty <OutputList /> because no looked-up column is returned. It's not the seek column (ProductID) that needs to be added to the index, it's the <Predicate> ... <ColumnReference>, Color.
@PaulWhite - can I get your opinion on "lock pages in memory" for a server with 3 instances, where each instance has 2000+ databases? We're using 2008 R2 Web Edition
Final point, the seek column will already be in the n/c index because otherwise how would it find the base row? All regular indexes include the cluster key/RID.
CREATE TABLE [dbo].[Client]
(
[SSNum] NCHAR(20) NOT NULL,
[CCNumberPrimary] NCHAR(20) NOT NULL,
[CCNumberSecondary] NCHAR(20) NOT NULL,
[CCNumberTertiary] BIGINT NOT NULL
)
CREATE CLUSTERED INDEX Client_Index ON Client (SSNum)
INSERT INTO [dbo].[Client] ([SSNum], [CCNumberPrim...
I type description about my game in All Application tab, in tab Game Services it required Display name and Description, I only need create LeaderBoard with Game Services, what should I type in Display name and Description?
I got office program. This program stores his data in SQL Server 2008 Express, but there is no management studio and no sqlcmd. How can i get into pure SQL tables, to use them in my plugin.
IDE: Microsoft SQL Server Management Studio
Mistakenly I have cleaned a table data using
delete from table tblBookData
and now it has cleaned that table, please tell me is there any way to get back that data?
If yes than please tell me the process, as I have studied there is a way to get ba...
How do I bump my own question? The problem is still very actual and I'm stuck.
Have an issue regarding the queries with GROUP BY. This is the following statement that I use so I can create the query:
SQL> SELECT invoice_num, technician_num, service_advisor, invoice_date_in, customer_id
2 FROM invoices_TP
3 GROUP BY invoice_date_in;
And this is error I get every time I t...
